| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
a protected cell w/formula only updates only on file save?
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. |
|
#2
|
|||
|
|||
|
Hi
First job - go to Tools|Options|Calculation tab and make sure Automatic is selected. -- Andy. "snap" wrote in message ... 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. |
|
#3
|
|||
|
|||
|
"snap" wrote:
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. You may have accidently turned off automatic calculation. Check ToolsOptionsCalculation and see if the Automatic radio button is selected |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
| Protected Cell | Excel Worksheet Functions | |||
| CELL PROTECTED IN 2000, UNPROTECTED IN 2003 | Excel Worksheet Functions | |||
| inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
Linear Mode
