Excel Cell Linking Not Updating 2

[Hakala]

Hi, Tek-tippers! I have a rather large workbook in Excel 2003 and suddenly the links and their associated math aren't updating when I add data.

For instance:
Cell CJ5 = the value of Cell CE9 (the previous day's ending inventory)
Cell CJ6 = incoming inventory today (typed)
Cell CJ7 = inventory removed today (typed)
Cell CJ8 = blank for visibility
Cell CJ9 = the value of Cell CJ5 plus CJ6 minus CJ7.

When I type the data in CJ6 and CJ7, the value of CJ9 isn't updating. It used to.

If I double-click in the cell CJ9, THEN it recalculates. The value in Cell CJ9 would be the start of the next day's column.

Two questions: Is there a way to fix this?
and
Is there a way to force the worksheet to recalculate all formulas/links?

Thank you for any help you can offer!

Michelle Hakala

http://www.winebird.com/

 

[AnotherHiggins]

[F9] will force it to recalculate, but the real issue sounds to be that calculations have been set to manual.

Go to [Tools > Options > Calculation and change to Automatic.

Or if you're in 2007, go to Office Button > Excel Options > Formulas

[tt][blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[Hakala]

That was it! Wonder why it worked for so long... Thank you so much....

Michelle Hakala

http://www.winebird.com/

 

[SkipVought]

FYI: If you have a workbook that takes a long time to calculate each time you make a change OR if you have many workbooks opens that also cause calculations to take a long time, consider, as a practice, setting Calculation to MANUAL and, rather than F9, which calculates EVERYTHING, only calculate the active sheet.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}