EXCEL TROUBLESHOOTING

[Gary B]

I have an excel file (2000 format), that after I made a
number of changes is causing me problems when I re-open
the file. Windows task manager goes to 100% CPU
activity, and i cant do anything within the excel file.
However, if I set recalculation to manual before I open
the file, all seems fine.

Obvioulsy I have a problem. But how do i find that
problem ?

Thanks in advance.

 

[Brian Clarke]

I have had some experience running large spreadsheets lately. Above a
certain size, the recalculation time seems to climb very fast. While Excel
is recalculating, you can't do anything anyway.

Best in my view to set recal to manual, work on the file, then press F9 just
before you take a break. Some of my sheets have taken an hour just to
recalculate, and while that's happening, you can't do anything else with the
PC.

Microsoft software, don't you just love it?