Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Automatic calculation reverting to manual depending upon who opens
The Accounts team just produced a Board report on our financial situation. An
email was sent out with an excel sheet attached. Both I and a colleague opened the file direct from Outlook and both saw significantly different results reported. His version of Excel had switched the Calculation tab (Tools/Options menu) to Manual - mine however remained as Automatic and reported the correct numbers. Despite having the same formulas in the same cells his was not summing the equations correctly. Why is this? |
#2
|
|||
|
|||
Not too hard to explain, if your colleague opened any workbook with
calculation set to manual as the first workbook he opened, then it will set the calculation for the next book(s) he opened as well -- Regards, Peo Sjoblom (No private emails please) "Pablito" wrote in message ... The Accounts team just produced a Board report on our financial situation. An email was sent out with an excel sheet attached. Both I and a colleague opened the file direct from Outlook and both saw significantly different results reported. His version of Excel had switched the Calculation tab (Tools/Options menu) to Manual - mine however remained as Automatic and reported the correct numbers. Despite having the same formulas in the same cells his was not summing the equations correctly. Why is this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
My Calculation Mode Changed to Manual Somehow?!? | Excel Discussion (Misc queries) | |||
How to automatic calculation and macro execution between 3 workbooks? | Excel Worksheet Functions | |||
Manual calculation does not work | Excel Discussion (Misc queries) | |||
"Manual calculation" takes less time. Why? | Excel Discussion (Misc queries) | |||
automatic calculation freezes | Excel Worksheet Functions |