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. |
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. |
"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 |
All times are GMT +1. The time now is 06:54 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com