Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculation Settings changing from automatic to manual
Anyone out there seeing their calc setting changing ? in the last 2 days I
have had 2 of my network users telling me their excel is not calculating...... possible a MS update has done something ???? wierd |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculation Settings changing from automatic to manual
It's not Microsoft.
Calculation mode is set by the first spreadsheet loaded. Your users are loading a spreadsheet which has Calc set to manual. It stays that way until reset. One typical way this happens is with a macro that's failed, or been interrupted. Regards, Fred "Dan DeCoursey" wrote in message ... Anyone out there seeing their calc setting changing ? in the last 2 days I have had 2 of my network users telling me their excel is not calculating...... possible a MS update has done something ???? wierd |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculation Settings changing from automatic to manual
If you open an Excel file which has the calculation mode set to
Manual, then all subsequent files opened in that session will also be set to Manual, and if you save them the Manual setting will then apply next time you open them. Just check the setting on the files you use, put it back to Automatic if necessary, and then save each file in turn. Hope this helps. Pete On Aug 12, 12:30*pm, Dan DeCoursey wrote: Anyone out there seeing their calc setting changing *? in the last 2 days I have had 2 of my network users telling me their excel is not calculating....... possible a MS update has done something ???? wierd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation changing from Automatic to Manual | Excel Discussion (Misc queries) | |||
Automatic/Manual Calculation | Excel Discussion (Misc queries) | |||
Settings Keep Changing to Manual Calculation | Excel Discussion (Misc queries) | |||
Automatic/Manual Calculation | New Users to Excel | |||
Manual / Automatic Calculation | Excel Discussion (Misc queries) |