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 / New Users / July 2006

Tip: Looking for answers? Try searching our database.

Automatic Calculation Issue

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dave - 27 Jul 2006 19:12 GMT
Hi,

I have a spreadsheet that I have created that includes many formulas,
conditional formatting, and links.  I brought up the spreadsheet today and
nothing was calculating automatically. I went to the Tools drop down and
under Options I noticed that the Calculation method changed from Automatic to
Manual.  

I didnt change this, does anyone know why this would have changed on it's
own??

Thanks,
Dave
Ken Wright - 27 Jul 2006 19:43 GMT
Probably no-one. Excel takes it's calculation state from the first workbook
you open after
launching an Excel session.  It may be that your personal.xls, or a
timesheet
file you use every day that launches automatically has been saved whilst in
manual mode.  Find and fix.

Signature

Regards
          Ken.......................    Microsoft MVP - Excel
             Sys Spec - Win XP Pro /  XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------­------------------------------­----------------

> Hi,
>
[quoted text clipped - 10 lines]
> Thanks,
> Dave
 
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.