Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Automatic Calculation" option intermittent
Occasionally when I open an Excel file and enter some data I discover that
the option to automatically recalculate all formulas has been cleared. I am talking about Excel Options | Formulas | Calculation Options | Workbook Calculation | Automatic. Windows XP, SP 3, Excel 2007, SP1 MSO. I do use a Personal.XLSB file. The file to which this happens contains a very large number of formulas, including conditional formatting. Does that have anything to do with it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Automatic Calculation" option intermittent
More than likely you have some other file where the setting is manual.
If you open that file first and then open your book in the same session the latest file will also adopt and retain the manual calc option. Best solution? Make sure that all your files are set to have automatic calc option. if this is impossible you need to set the calc option each time you open this file via a macro. -- Greetings from New Zealand "Renny Bosch" wrote in message ... Occasionally when I open an Excel file and enter some data I discover that the option to automatically recalculate all formulas has been cleared. I am talking about Excel Options | Formulas | Calculation Options | Workbook Calculation | Automatic. Windows XP, SP 3, Excel 2007, SP1 MSO. I do use a Personal.XLSB file. The file to which this happens contains a very large number of formulas, including conditional formatting. Does that have anything to do with it? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"Automatic Calculation" option intermittent
Bill, doesn't the fact that I use a Personal.xlsb file ensure that that file
is always the first to be opened? If I open an email attachment which is an Excel file, could that screw up my setting? "Bill Kuunders" wrote in message ... More than likely you have some other file where the setting is manual. If you open that file first and then open your book in the same session the latest file will also adopt and retain the manual calc option. Best solution? Make sure that all your files are set to have automatic calc option. if this is impossible you need to set the calc option each time you open this file via a macro. -- Greetings from New Zealand "Renny Bosch" wrote in message ... Occasionally when I open an Excel file and enter some data I discover that the option to automatically recalculate all formulas has been cleared. I am talking about Excel Options | Formulas | Calculation Options | Workbook Calculation | Automatic. Windows XP, SP 3, Excel 2007, SP1 MSO. I do use a Personal.XLSB file. The file to which this happens contains a very large number of formulas, including conditional formatting. Does that have anything to do with it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Why is the "zoom" option grayed out in "print preview?" | Excel Discussion (Misc queries) | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
pictures to work with "data" "sort" option | Excel Discussion (Misc queries) | |||
Disabling "SAVE AS" option under "File" | Excel Discussion (Misc queries) |