Thread: Calculate
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Anant Arde Anant Arde is offline
external usenet poster
 
Posts: 1
Default 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