Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas aren't calculating
I have a spreadsheet that has simple sum formulas and conditional formatting
in the cells with the sum formulas. My formulas have stopped calculating and any new formulas that I enter do not calculate. Any idea what might be causing this? Thanks for your help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas aren't calculating
Is you calculation on manual?
Tools Options Calculation Make sure it's set to automatic. "sferguson" wrote: I have a spreadsheet that has simple sum formulas and conditional formatting in the cells with the sum formulas. My formulas have stopped calculating and any new formulas that I enter do not calculate. Any idea what might be causing this? Thanks for your help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formulas aren't calculating
ToolsOptionsCalculation can be Auto or Manual.
Excel takes the Calculation mode each session from the settings on the first workbook opened in that session. i.e. If you saved Book1 with calc mode in manual and opened it first, calc mode would be in Manual. If you saved Book2 with calc mode in auto and opened it after Book1, Book2 would be in manual mode(Excel ignores the auto calc mode in this case). If you close Book1 before opening Book2, Book2 will be in auto calc mode. Confusing enough? <g Gord Dibben MS Excel MVP On Wed, 9 Sep 2009 12:44:31 -0700, sferguson wrote: I have a spreadsheet that has simple sum formulas and conditional formatting in the cells with the sum formulas. My formulas have stopped calculating and any new formulas that I enter do not calculate. Any idea what might be causing this? Thanks for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas not calculating | Excel Discussion (Misc queries) | |||
Formulas not calculating | Excel Worksheet Functions | |||
not calculating formulas | Excel Discussion (Misc queries) | |||
Formulas not calculating??? | Excel Discussion (Misc queries) | |||
Formulas not calculating | Excel Worksheet Functions |