Problem
worksheet is too large, running out of memory when rows are deleted or inserted, running
much slower
Column IV problem
for MacNail construction
software
Diagnosis
1. Unprotect document if necessary.
2. Choose Goto from Formula menu, and type in IV1 (eye-vee-one).
3. Choose Column width from the Format menu, and type in a number
4. Choose Select Special from the Formula menu, select Last Cell, click OK
5. If selection is in normal 'far right' column, it's OK. If in column IV, the worksheet
includes many extra blank columns that are causing the problem.
Solution
1. Choose Display from Options menu, and turn on Row & Column Headings
2. Select all the columns from the one immediately to the right of the 'far right' regular
column to column IV. Shift-drag on the bottom slider gets you all the way over to column IV quickly.
3. Choose Delete from the Edit menu. When asked to continue without Undo, click OK. If not
enough memory, give XL more memory and/or restart without extensions (see items 30, 134)
4. Save. Close. Reopen. To check results, repeat step 4 under 'diagnosis'.
Comments
ALTERNATE METHOD OF REPAIR:
1. Make a new worksheet of that type.
2. Add enough rows to contain the data from the damaged worksheet.
3. Select the data in the damaged worksheet, and choose Copy.
4. Select the first cell in the new worksheet, and choose Paste. (if that doesn't work, may
need to copy/paste data in smaller blocks).
5. Close all files, rename the damaged file to something else, rename the fixed file to the
original file name.
NOTE: With XL 3, you can't hide the blank extra columns afterwards without having the last
cell jump to column IV again, so you'll just have to leave them showing. With XL 2.2 or 4+ that's not
a problem.
Entered 1/5/94 by Dennis. Updated 11/13/2010.
|
