Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2008

Tip: Looking for answers? Try searching our database.

Formula

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cherie - 13 Mar 2008 13:50 GMT
Why do I have to click the formula line every time to get the cell to update.
I put in the numbers and the cell with the formula does not update until I
click on the formula line. How do I fix this so it updates automatically?
Max - 13 Mar 2008 14:01 GMT
Probably calc mode is "inadvertently" set to manual
Click Tools > Options > Calculation tab > Check "Automatic" > OK
Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Why do I have to click the formula line every time to get the cell to update.
> I put in the numbers and the cell with the formula does not update until I
> click on the formula line. How do I fix this so it updates automatically?
Cherie - 13 Mar 2008 14:27 GMT
Thank you so much.

> Probably calc mode is "inadvertently" set to manual
> Click Tools > Options > Calculation tab > Check "Automatic" > OK
> > Why do I have to click the formula line every time to get the cell to update.
> > I put in the numbers and the cell with the formula does not update until I
> > click on the formula line. How do I fix this so it updates automatically?
Max - 13 Mar 2008 20:07 GMT
welcome
Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> Thank you so much.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.