On 3/23/2011 1:12 PM, Pat Collett wrote:
Using Calc on Windows Vista.
It keeps locking, shutting down and then having to recover in the
middle of using the file (about 2.4Mb)
It's got to where I can't work on the file.
What's up and what can I do?
Pat.
[email protected] <mailto:[email protected]>
If 2.4 MB is the file-size in .ods format, it's actually much larger
in working format (.ods files are zipped for storage; their uncompressed
size when in memory can e much greater.) Here are some of the things
I've considered in trying to reduce the size and complexity, and hence
the frequent "bombing":
1. Am I trying to do too many loosely related things in one spreadsheet
file? If so maybe I should use separate spreadsheets for the different
tasks -- a Divide and Conquer strategy. The first step is to use Save
As to create a second version, say for Task B; if there are additional
tasks, say C and D, then repeat the Save As process to create additional
versions of the original. Then, with the last Saved-As version, delete
sheets not needed for that Task. Next reopen the original version,
which will now be used only for Task A, and delete sheets not needed for
Task A. Repeat this process as needed to pare each version down to just
what is needed for the corresponding task.
2. Are there pages (sheets) whose content will never change but which
contain many formulas? If so I convert those sheets to all values via
the following steps. On a page to be converted, press Ctrl+End, then
Shift+Ctrl+Home to select the entire sheet, then Ctrl+C to copy, then
Shift+Ctrl+V to invoke the Paste-Special dialog box. The first time you
do this you would probably need to uncheck the Paste all box; then
uncheck Formulas, Notes and Objects, and check Text, Numbers and Date &
Time; then click OK (or press Enter) to complete the conversion
I hope this helps
--
------------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected] with Subject: help
