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.
0
snap (2)
5/18/2005 11:18:03 AM
excel.misc 78881 articles. 5 followers. Follow

2 Replies
331 Views

Similar Articles

[PageSpeed] 2

Hi
First job - go to Tools|Options|Calculation tab and make sure Automatic is 
selected.

-- 
Andy.


"snap" <snap@discussions.microsoft.com> wrote in message 
news:EBD853AC-9B80-4C90-9029-482266CE1A67@microsoft.com...
>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. 


0
Andy
5/18/2005 11:25:29 AM
"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 
Tools>Options>Calculation and see if the Automatic radio button is selected
0
bigwheel926 (227)
5/18/2005 11:35:12 AM
Reply:

Similar Artilces: