Calc = Manual & Do Not Calc b/4 SAVE

K

Ken

Excel2003 ... I have a WorkBook (not linked) consisting of 4 WorkSheets ...
(3 WorkSheets with 10000 records & 1 WorkSheet with 2000 records) with many
formulas working between sheets. Calculation takes about 20 minutes ... I
have Calculation set to Manual ... & am now removing "check" mark from "Calc
before Save" ... I use Manual Calc often to speed sheets, but have always
Calculated before SAVE.

Above said ... Since WorkBook is not linked to any other WorkBook are there
Any pitfalls to watch for if I remove "check" mark from "Calc before SAVE"?

Thanks for the guidance ... Kha
 

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

Switching to Manual Calculation stalls workbook 1
Open CSV causes calculation in manual calc mode 0
Data entry too slow even with calc set to manual 1
Sumproduct and speed of Calc. 4
Calc Speed & Formula simplification 2
Excel - Not calculating formulas 1
Workbook causes calculation errors 2
Subtotal Flaw - Is this a Bug? 4

Top