AutoCalc in Excel is stuck!
Hi all... I have a spreadsheet that is not updating formulas when changes are
made. The options are set correctly to autocalc, and I've read all of the advice here about how Excel gets it's settings from the first excel file opened in a session. I've closed Excel, reopened. Open a blank worksheet, verified that it's set to auto calc. Then I open the troubled file and it has the 'calculate' in the bottom left-hand side. If I go in to options, it's still checked at Auto, even though it isn't working. Ideas? |
AutoCalc in Excel is stuck!
Check this list:
http://xldynamic.com/source/xld.xlFAQ0024.html -- Kind regards, Niek Otten Microsoft MVP - Excel "LR" wrote in message ... | Hi all... I have a spreadsheet that is not updating formulas when changes are | made. The options are set correctly to autocalc, and I've read all of the | advice here about how Excel gets it's settings from the first excel file | opened in a session. | | I've closed Excel, reopened. Open a blank worksheet, verified that it's set | to auto calc. Then I open the troubled file and it has the 'calculate' in | the bottom left-hand side. If I go in to options, it's still checked at | Auto, even though it isn't working. | | Ideas? |
AutoCalc in Excel is stuck!
Thanks Niek.. looks like I have hit likely hit the dependency limit... thanks
for the help! "Niek Otten" wrote: Check this list: http://xldynamic.com/source/xld.xlFAQ0024.html -- Kind regards, Niek Otten Microsoft MVP - Excel "LR" wrote in message ... | Hi all... I have a spreadsheet that is not updating formulas when changes are | made. The options are set correctly to autocalc, and I've read all of the | advice here about how Excel gets it's settings from the first excel file | opened in a session. | | I've closed Excel, reopened. Open a blank worksheet, verified that it's set | to auto calc. Then I open the troubled file and it has the 'calculate' in | the bottom left-hand side. If I go in to options, it's still checked at | Auto, even though it isn't working. | | Ideas? |
All times are GMT +1. The time now is 11:10 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com