Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Overriding the calculation state
Hi all. Hope someone can help.
I have a workbook with custom functions which fetch data via odbc from a database. I have disabled auto calculation when opening the workbook as I wish to control the order in which the workbook is calculated, which is:- 1. Calulate worksheet 1 2. Sort the data based upon the result of some calculations 3. Calculate worksheet 2 4. Sort the data based upon the result of some calculations 5. And so on until the last worksheet is processed. The user would then print as necessary, save the workbook, and then close it. My problem is that after the sort has been completed, Excel considers that the workbook needs calculating again, even though I do not need it to. When the user saves the workbook, as the calculation state is now pending, Excel now calculates (which takes some considerable time) before saving. Can I override this pending state in some way? If not, what other possible solutions are available to me? Thanks in advance. A gold star for the best answer! -- Alan Moseley IT Consultancy http://www.amitc.co.uk If I have solved your problem, please click Yes below. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent formula calculation from overriding validation | Excel Worksheet Functions | |||
replace state names with state code abbreviations | Excel Worksheet Functions | |||
Calculation state | Excel Programming | |||
Converting State Names to State Abbreviations | Excel Discussion (Misc queries) | |||
Detecting Calculation State | Excel Programming |