Calculate
Hi,
I am Anant Basant from New Delhi India. I have been looking for any answers for a typical problem in Excel that occurs every now and then. When I open a file it starts showing calculate. I have tried the following : 1. Turn calculation mode to Automatic from Options 2. From immediate window "Application.Calculation=xlCalculationAutomati c " Nothing happens. If I open and close the file 4 or 5 times, it goes, but I am still searching for the causes. Any help would be much appreciated. Thanks Anant |
Calculate
Calculation mode is an application setting that's picked up from the first
workbook that you open in that session. So if the first workbook you open has calculation set to manual, then excel will be in manual calculation mode. If the first workbook you open has calculation set to automatic, then excel will be in automatic calculation mode. If you notice that tools|options|calculation tab has calculation set for automatic, maybe it's this situation: http://support.microsoft.com/default.aspx?scid=243495 XL: Calculate Message Remains in Status Bar If 65,536 Formula References Anant Arde wrote: Hi, I am Anant Basant from New Delhi India. I have been looking for any answers for a typical problem in Excel that occurs every now and then. When I open a file it starts showing calculate. I have tried the following : 1. Turn calculation mode to Automatic from Options 2. From immediate window "Application.Calculation=xlCalculationAutomati c " Nothing happens. If I open and close the file 4 or 5 times, it goes, but I am still searching for the causes. Any help would be much appreciated. Thanks Anant -- Dave Peterson |
All times are GMT +1. The time now is 07:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com