Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel auto-calculate
- Thread starter Rosebud
- Start date
Excel is a bit funny with the settings for each workbook that is open. Make sure when you open it there are no other workbooks open in excel. then check the setting. Set it to auto calculate then save it.
If another workbook is open with Manual calculate excel is likely to set Manual calulate to other open workbooks.
It depends on the order in which you open workbooks.
If another workbook is open with Manual calculate excel is likely to set Manual calulate to other open workbooks.
It depends on the order in which you open workbooks.
- Thread starter
- #3
- Thread starter
- #5
I only have one workbook open, and it has a number of worksheets. Do I have to change the preference settings on each worksheet? I misstated in my original message - after changing the settings I close the workbook - not just the worksheet. When I reopen the workbook, autocalculate is back to being turned off.
I was hoping there would be an easy fix to this!
I was hoping there would be an easy fix to this!
Auto and Manual Calculate is on for the Entire Workbook. You can not set it for individual sheets.
If It is the ONLY WORKBOOK open when you SAVE it with Auto Calculate and it is the FIRST AND ONLY WORKBOOK you OPEN then auto calculate should still be set.
If it isn't the only thing I can think of is that there is a macro setting it to Manual Calculate everytime you open it.
If you like you can send me the file and I can check it.
dark_suns@lycos.com
If It is the ONLY WORKBOOK open when you SAVE it with Auto Calculate and it is the FIRST AND ONLY WORKBOOK you OPEN then auto calculate should still be set.
If it isn't the only thing I can think of is that there is a macro setting it to Manual Calculate everytime you open it.
If you like you can send me the file and I can check it.
dark_suns@lycos.com
Does your computer have a file named book.xlt that is saved in your xlstart directory? (perhaps done to customize new workbooks, which happened to be saved with calculation off?)
If so, resave template with calculation off, or delete book.xlt if you desire no automatic customization of new workbooks
If so, resave template with calculation off, or delete book.xlt if you desire no automatic customization of new workbooks
- Status