 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2004Automatic Calculation Not happening
Using Excel 2002 on XP Pro, some of my network users (2 so far) have reported that Automatic Calculation of their spreadsheets is not happening. This seems selective in that some spreadsheets work and some don't. Automatic Calculation IS turned on in Optioons, but does not happen. Only way to calculate is to F9 and perform a manual calculation. There are no macros running anywhere . Can anyone suggest any advice? Thanks The Calculation option, while a global setting, is saved in each workbook, and the instance of XL will take its setting from the first workbook that opens. So if you open a workbook that was saved with Calculation set to Manual, then all other workbooks that are opened in that instance of XL will also be in Manual Calculation mode, even if they were last saved in Automatic. > Using Excel 2002 on XP Pro, some of my network users (2 so far) have > reported that Automatic Calculation of their spreadsheets is not happening. [quoted text clipped - 8 lines] > > Thanks Actually opening the options within the file which will not auto-calculate shows it turned ON. This is what is confusing me. I could understand if it had been turned off previously but it indicates it is ON and does not work. > The Calculation option, while a global setting, is saved in each > workbook, and the instance of XL will take its setting from the first [quoted text clipped - 17 lines] > > > > Thanks Was it the first file opened in that instance of XL? Is there a Personal.xls or other file in the XLStart folder (which opens when XL is started) that has Calculation set to Manual? > Actually opening the options within the file which will not auto-calculate > shows it turned ON. > > This is what is confusing me. I could understand if it had been turned off > previously but it indicates it is ON and does not work. No, there is nothing opening first (either in the background) or by the user. I have reformatted one of the problem machines (for other reasons) about a week ago and reinstalled Office XP Pro with SP3 and they are still having problems. Now today a second user reported the problem. > Was it the first file opened in that instance of XL? Is there a > Personal.xls or other file in the XLStart folder (which opens when XL is [quoted text clipped - 5 lines] > > This is what is confusing me. I could understand if it had been turned off > > previously but it indicates it is ON and does not work. I don't know if this is the case with your problem, but a lot of time when auto calculation doesn't work, its because there is a circula reference problem. You might try going thru excel's troubleshooting tips on circula references, to see if this is the problem -- Message posted from http://www.ExcelForum.com |
Reply to this Message |
 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.