Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Workbook not caculating formulas
I have had this problem before and fixed it but I am drawing a blank. None of the formulas in my workbook will caculate until it is saved and closed or the user hits F9. (The user dropped a book on his keyboard and toggled something). I went into TOOLS-OPTIONS_ CACULATIONS and Automatic is chosen but it still isn't doing it. Any ideas suggestions? I know it will be something easy but I can't remember it.
Thanks, Rod |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook not caculating formulas
I've never seen this problem.
But I've seen posts that describe this. I'd select all the worksheets (rightclick on a tab and choose Select all sheets then select A1 (just so a single cell is selected edit|Replace what: = with: = replace all then ungroup the sheets RodShaw2 wrote: I have had this problem before and fixed it but I am drawing a blank. None of the formulas in my workbook will caculate until it is saved and closed or the user hits F9. (The user dropped a book on his keyboard and toggled something). I went into TOOLS-OPTIONS_ CACULATIONS and Automatic is chosen but it still isn't doing it. Any ideas suggestions? I know it will be something easy but I can't remember it. Thanks, Rod -- RodShaw2 -- Dave Peterson |
#3
|
|||
|
|||
Sorry I should have been a bit more clear. None of the workbooks or worksheets on that computer will automatically caculate.
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Workbook not caculating formulas
Excel determines the calculation mode from the first workbook opened in that
session. It sounds like you may have changed it once and expected it to stay set that way forever. I'd open a workbook and check that calculation setting once more. RodShaw2 wrote: Sorry I should have been a bit more clear. None of the workbooks or worksheets on that computer will automatically caculate. -- RodShaw2 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Do not want formulas to reference old workbook. | Excel Discussion (Misc queries) | |||
Using formulas between different sheets in the same workbook | Excel Discussion (Misc queries) | |||
Caculating Columns Between Certain Dates | New Users to Excel | |||
Caculating a "staircase" discount | Excel Worksheet Functions | |||
Workbook formulas | Excel Worksheet Functions |