Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate Cells - Time consuming!
Please help. I've got a "data" sheet updating via ADO from SQL. Another sheet
has formulas like Vlookup & Sumproduct linked to the "data" sheet. After the data update a bunch of macros are run on the data sorting and standardising the data and every time a change is made all the formulas try and re-calculate. I've tried setting Tools - Calculation - Manual but every time I run the macro the calculation state changes back to Auto. I've also tried Application.Calculation = xlCalculationManual & Application.ScreenUpdating = False but it makes no diffirence. Is there any other way of not having these formulas updating automatically? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculate Cells - Time consuming!
In my limited experience with ADO I have not found that running a query by
itself changes the calc mode. Maybe if you looked through the macros that do the sorting, etc., you'd find where calc mode was being changed to automatic. -- Jim "Braindeadbeachbum" wrote in message ... | Please help. I've got a "data" sheet updating via ADO from SQL. Another sheet | has formulas like Vlookup & Sumproduct linked to the "data" sheet. After the | data update a bunch of macros are run on the data sorting and standardising | the data and every time a change is made all the formulas try and | re-calculate. I've tried setting Tools - Calculation - Manual but every time | I run the macro the calculation state changes back to Auto. I've also tried | Application.Calculation = xlCalculationManual & Application.ScreenUpdating = | False but it makes no diffirence. Is there any other way of not having these | formulas updating automatically? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate the difference in date/time formatted cells | Excel Discussion (Misc queries) | |||
Extreme, time-consuming processing | Excel Discussion (Misc queries) | |||
Calculate time difference between cells | Excel Discussion (Misc queries) | |||
Resource / Time consuming macro | Excel Programming | |||
Consuming excel events in C# | Excel Programming |