Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel not calculating formulas
* Problem occurs in Office 2000/3
We have some excel files that will not automatically calculate formulas. The option for automatic or manual calculations is set to automatic. We have read other posts about Excel having a "trap" where it takes the calculation option (auto/manual) from the first file that is open. Then applies that to subsequent files that are opened after it. We have not been able to verify this in our tests. We have went through all of our excel files on our systems and none of our files have the manual setting. The only way to get calculations to work is to close the file and reopen the file. Upon reopening of the file, the formulas update/calculate. The problem is on many machines. Reinstallation of Office itself has not resolved the problem. Applying the latest patches has not resolved the problem. Looking for some help. It would greatly be appreciated. This drives our users crazy. Thank you! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel formulas not calculating | Excel Discussion (Misc queries) | |||
Excel 03 Stopped Calculating Formulas | Excel Discussion (Misc queries) | |||
Excel not calculating formulas | Excel Worksheet Functions | |||
calculating formulas in excel | Excel Worksheet Functions | |||
Help, Urgent Excel Formulas are not calculating | Excel Discussion (Misc queries) |