Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Autocalculate
Today a user experienced a situation where a spreadsheet that he had open did
not calculate properly. The auto-calculate function was turned on, but when inputs were changed, the final results would remain unchanged until he hit the "super-calculate" function (control-alt-f9). He would then watch the final results change. He had another excel file open at the time (Note: these files were not linked). When he closed this file, the problem corrected itself. |
#2
|
|||
|
|||
The other sheet was probably opened first and reset calculation to manual..
Check it's options. -- Don Guillett SalesAid Software "Chris" wrote in message ... Today a user experienced a situation where a spreadsheet that he had open did not calculate properly. The auto-calculate function was turned on, but when inputs were changed, the final results would remain unchanged until he hit the "super-calculate" function (control-alt-f9). He would then watch the final results change. He had another excel file open at the time (Note: these files were not linked). When he closed this file, the problem corrected itself. |
#3
|
|||
|
|||
How large was the file that acted up? I have seen this problem surface with
large spreadsheets that have many calculations "Chris" wrote in message ... : Today a user experienced a situation where a spreadsheet that he had open did : not calculate properly. The auto-calculate function was turned on, but : when inputs were changed, the final results would remain unchanged until : he hit the "super-calculate" function (control-alt-f9). He would then : watch the final results change. : : He had another excel file open at the time (Note: these files were not : linked). When he closed this file, the problem corrected : itself. |
#4
|
|||
|
|||
How is that possible if the spreadsheets aren't linked?
"Don Guillett" wrote: The other sheet was probably opened first and reset calculation to manual.. Check it's options. -- Don Guillett SalesAid Software "Chris" wrote in message ... Today a user experienced a situation where a spreadsheet that he had open did not calculate properly. The auto-calculate function was turned on, but when inputs were changed, the final results would remain unchanged until he hit the "super-calculate" function (control-alt-f9). He would then watch the final results change. He had another excel file open at the time (Note: these files were not linked). When he closed this file, the problem corrected itself. |
#6
|
|||
|
|||
I spoke with the user and he told me that he knew that because "calculate"
would appear on wb at the bottom left. He also said that F9 should calculate the wb when set to manual, but he had to do a Crtl+F9. Is there any other possible cause and solution? Thanks "Don Guillett" wrote: The first wb to open sets the calculation. -- Don Guillett SalesAid Software "Chris" wrote in message ... How is that possible if the spreadsheets aren't linked? "Don Guillett" wrote: The other sheet was probably opened first and reset calculation to manual.. Check it's options. -- Don Guillett SalesAid Software "Chris" wrote in message ... Today a user experienced a situation where a spreadsheet that he had open did not calculate properly. The auto-calculate function was turned on, but when inputs were changed, the final results would remain unchanged until he hit the "super-calculate" function (control-alt-f9). He would then watch the final results change. He had another excel file open at the time (Note: these files were not linked). When he closed this file, the problem corrected itself. |
#7
|
|||
|
|||
Open the destination wb first or put a change to automatic calculation in
the workbook_open and/or auto_open -- Don Guillett SalesAid Software "Chris" wrote in message ... I spoke with the user and he told me that he knew that because "calculate" would appear on wb at the bottom left. He also said that F9 should calculate the wb when set to manual, but he had to do a Crtl+F9. Is there any other possible cause and solution? Thanks "Don Guillett" wrote: The first wb to open sets the calculation. -- Don Guillett SalesAid Software "Chris" wrote in message ... How is that possible if the spreadsheets aren't linked? "Don Guillett" wrote: The other sheet was probably opened first and reset calculation to manual.. Check it's options. -- Don Guillett SalesAid Software "Chris" wrote in message ... Today a user experienced a situation where a spreadsheet that he had open did not calculate properly. The auto-calculate function was turned on, but when inputs were changed, the final results would remain unchanged until he hit the "super-calculate" function (control-alt-f9). He would then watch the final results change. He had another excel file open at the time (Note: these files were not linked). When he closed this file, the problem corrected itself. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoCalculate doesn't see my data | Excel Discussion (Misc queries) | |||
How do I autocalculate a single number? | Excel Worksheet Functions | |||
Shortcut for autocalculate | Excel Discussion (Misc queries) |