a protected cell w/formula only updates only on file save?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel worksheet that use to work fine. Now all of a sudden the cell
with a formula no longer updates automatically. It only updates the
calculated cell once I save the file.
 
Hi
First job - go to Tools|Options|Calculation tab and make sure Automatic is
selected.
 
snap said:
I have an excel worksheet that use to work fine. Now all of a sudden the cell
with a formula no longer updates automatically. It only updates the
calculated cell once I save the file.
Click to expand...

You may have accidently turned off automatic calculation. Check
Tools>Options>Calculation and see if the Automatic radio button is selected
 
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

Sheet Names and Auto-calculation 2
excel cells changing to "#VALUE!" whenever another file is opened 8
Excel Protection 2
Cell protection and changing links 1
Tracking Access in Read-Only Files 0
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Cell Protection? 2
Backwards Compatibility with Excel 2002 2

Back
Top