Here's something I can't quite figure out. I manipulate some large spreadsheets and have therefore turned off the auto-calc feature, or at least I thought. The problem is, every time I open one of these workbooks excel auto-calcs anyway, taking as long as 10 minutes at times.
Anyone have any tips to resolve this? I'm working in Office 2003 on XP SP2.
Thanks!
In the open event of ThisWorkBook use this code to disable autocalculation
Use this to reset it to automatic, if required, in the before close event
Please Login or Register to view this content.
To access the event editor, hit Alt+F11 and double-click ThisWorkbook for the workbook you're working with, in the Project Explore (on the left side of the screen).Please Login or Register to view this content.
Then select Workbook from the 1st drop down in the main editor area and select Open from the second drop down. Insert the first statemend above before the End Sub statement.
Then select Before Close from the 2nd drop down and new sub should appear...enter the second statement in there.
Save the workbook.
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thanks, but can I just set it for Excel as a whole?
I have done it in the options menu but again, it still calculates when I open the workbook. The thing is, I have to create this workbook anew daily and so don't want to have to do this every day.
Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks