Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WB Not Calculating Automatically
Hi,
We are using Office 2003, and use many WB's, last night one particular WB when cells were changed would not update simple formulas. I have checked that the calculation tab is set to automatic as I know this can cause this. Even in the WB pressing F9 at the time would also not work. Don't know if it's any coincidence but we have just upgrade to Windows XP operating system. Any suggestions out there. Many thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
WB Not Calculating Automatically
Does this file act the same on different computers?
If not, then the problem is probably with the computer where it acts up. If so, then one possibility might be that a macro is turning off calculations as the workbook is opened......try starting the file with macros disabled to see if this might be the cause....... hth Vaya con Dios, Chuck, CABGx3 "Jon Martin" wrote: Hi, We are using Office 2003, and use many WB's, last night one particular WB when cells were changed would not update simple formulas. I have checked that the calculation tab is set to automatic as I know this can cause this. Even in the WB pressing F9 at the time would also not work. Don't know if it's any coincidence but we have just upgrade to Windows XP operating system. Any suggestions out there. Many thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automatically update cells | Excel Discussion (Misc queries) | |||
Excel file automatically opens - More Info | Excel Discussion (Misc queries) | |||
need help w/formula for calculating overtime hours | Excel Worksheet Functions | |||
Automatically Populating Worksheet from Collected Input for Pricelist | Excel Worksheet Functions | |||
Automatically Populating Worksheet from Collected Input for Pricelist | Excel Worksheet Functions |