Cells not automatically changing

  • Thread starter Thread starter msherman83
  • Start date Start date
M

msherman83

I have two worksheets, one that lists all of my expenses and anothe
that I am summarizing this info on.

I am using a SUMIF formula that sums based on what type of expense. M
problem is that when I change the amount of the expense on the firs
sheet, the sum does not update itself automatically on the second shee
where the SUMIF cell is located. It will only change it if I save th
workbook.

Why does it require that I save before it updates the linked cells?

Any thoughts would be greatly appreciated! Thanks
 
Hi
have you checked that automatic calculation is enabled?. Does hitting
F9 update the formula result?
 
Similar thoughts as Frank's ..

Perhaps calculation mode has inadvertently been "switched",
without** your knowledge, to "Manual" / Recalculate before save ?
(that would explain what you observed)

Try pressing F9. Do the formulas now compute properly ?

---------
To change / check calc mode settings:
-------------------------------------
Click Tools > Options > Calculation tab
Check what's showing under "Calculation"
Click to set as desired > OK
(default / usual setting is "Automatic")

---
**The calculation mode of each Excel session
is dictated by the calc mode of the first book opened
within the session.

For example, if the first book's calculation mode is "Manual",
then the mode for all subsequent books opened in the same
Excel session (i.e. until / unless Excel is exited) will
be "Manual", irregardless of their earlier saved modes.
 
Back
Top