How to troubleshoot a slow file

N

NewUser23

Hi,

I've got a file that has a handful of calc fields derived off the data in the same worksheet. Its got about 1200 rows, and basically locks up whenever I edit, delete a row/column or cut & paste. It seems I probably in "looping" one of my calcs. Is there a way to troubleshoot this?

Thanks.

Jocelyn
 
M

Max

You could also try changing calc mode to
either "Manual" or "Automatic except Tables" ?

Click Tools > Options > Calculation tab
Check "Manual" or "Automatic except Tables" > OK

--
Rgds
Max
xl 97
----------------------------------------------------
Use xdemechanik <at>yahoo<dot>com for email
-----------------------------------------------------
NewUser23 said:
Hi,

I've got a file that has a handful of calc fields derived off the data in
Click to expand...
the same worksheet. Its got about 1200 rows, and basically locks up
whenever I edit, delete a row/column or cut & paste. It seems I probably in
"looping" one of my calcs. Is there a way to troubleshoot this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cell data entering slow! 0
this code is VERY slow, is it the code or perhaps a worksheet issue 32
Synchronization problems while moving folders to new email 1
How do I allow user to edit value in continouos form - aaaarggghhh!! 3
Excel Extremely Slow 2
Lessons from optimizing a slow spreadsheet 2
Named Range COUNTA fails when 1st record deleted 1
Contents of Formula Bar overflow cells 4

Top