Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I've been working on a new spreadsheet for several weeks. All of the
formulas stopped working in it today. I opened some other Excel files and they stopped working as well. If I change a value in a cell that the formula cell should calculate, it doesn't change. HOWEVER, if I double click on the formula cell, then enter, it calculates. Any clue as to what's happening? |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Set the calc "switch" to Auto!
<Tools <Options <Calculation tab. -- HTH, RD ================================================== === Please keep all correspondence within the Group, so all may benefit! ================================================== === "djcircman" wrote in message ... I've been working on a new spreadsheet for several weeks. All of the formulas stopped working in it today. I opened some other Excel files and they stopped working as well. If I change a value in a cell that the formula cell should calculate, it doesn't change. HOWEVER, if I double click on the formula cell, then enter, it calculates. Any clue as to what's happening? |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Tools/Options/Calculate. Select Automatic.
In article , djcircman wrote: I've been working on a new spreadsheet for several weeks. All of the formulas stopped working in it today. I opened some other Excel files and they stopped working as well. If I change a value in a cell that the formula cell should calculate, it doesn't change. HOWEVER, if I double click on the formula cell, then enter, it calculates. Any clue as to what's happening? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel has stopped working | Setting up and Configuration of Excel | |||
Linked Formulas have stopped working! | Excel Worksheet Functions | |||
formulas have stopped working automatically | Excel Discussion (Misc queries) | |||
why formulas have stopped working in Excel? | Excel Worksheet Functions | |||
VB Stopped Working | Excel Worksheet Functions |