Formulas not updating until save

  • Thread starter Thread starter DKY
  • Start date Start date
D

DKY

I have Excel 2003 and I noticed that a lot of my formulas in a
particular worksheet are not updating if I change the values that they
depend on until I save the sheet. Is there a workaround for that?
 
DKY,

Set your calculation mode to automatic. Tools / Options / Calculation tab.

HTH,
Bernie
MS Excel MVP
 
Select all the cells.
edit|replace
what: =
with: =
replace all

Maybe it'll wake excel up.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a template that I can reproduce every month by keying ininformation from SAP 8
insert blank row and formulas 1
Why do Excel cells not calculate until I hit "save" 2
Formulas do not update 2
I want to save a copy of a wksht. but without any of the formulas 5
Must save to view formula results 6
Excel How to get the number of days an item was opened from the today's date. 14
Counting multiple memberships 1

Back
Top