My calculation mode sets to manual everytime I save or open Excel. Please help
A Amit Dec 30, 2003 #1 My calculation mode sets to manual everytime I save or open Excel. Please help
J J.E. McGimpsey Dec 30, 2003 #2 Calculation mode is set by the first workbook opened in an XL session. Check your file that you use to start XL, or, if you start the application first, check the items in your startup folder (including Personal.xls).
Calculation mode is set by the first workbook opened in an XL session. Check your file that you use to start XL, or, if you start the application first, check the items in your startup folder (including Personal.xls).
M Max Dec 30, 2003 #3 Try saving a new workbook with the calculation mode set to Automatic as Book.xlt in XLSTART folder (template file) Open a new (empty) book Click Tools > Options > Calculation tab > Check "Automatic" > OK Click File > Save As: Select under "Save as type:" : Template Put as "File name:" : Book Navigate to (for "Save in:"): C:\Program Files\Microsoft Office\Office\XLStart Click Save
Try saving a new workbook with the calculation mode set to Automatic as Book.xlt in XLSTART folder (template file) Open a new (empty) book Click Tools > Options > Calculation tab > Check "Automatic" > OK Click File > Save As: Select under "Save as type:" : Template Put as "File name:" : Book Navigate to (for "Save in:"): C:\Program Files\Microsoft Office\Office\XLStart Click Save
