I have a large XL workbook that takes 12 to 15 seconds to calculate.
It resides on the network, so everyone can access it and add data as required. I keep it on manual for calcualtion, so people can enter all the data and at the end hit F9 to calculate.
The problem is, the setting gets changed to automatic and its annoying to other people, when they have to wait after every entry. I don't know what's changing the setting.
Is there a VBA code or Macro that can make the workbook default to Manual when you open the workbook. This way it will always open with Manual setting.
Thanks,
modytrane
This will do that
However, I would investigate why the workbook is taking so long to calculate.Option Explicit Private Sub Workbook_Open() Application.Calculation = xlCalculationManual End Sub
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
Thanks,
It works.
The calucations take time, because the workbook has one sheet as a master database with over 400 rows and 20 columns of data.
There are 18 other sheets that draw information from this database to generate a variety of summary reports and Graphs. Some of the summary reports have error checking formulas that look for missing data and alert the user if they didn't fill in certain information on the database sheet.
With your code it defaults to Manual calculation and its only a one time wait at the end, after all the changes have been made.
Thanks again,
modytrane.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks