I have some fairly large reports that utilize the SUMPRODUCT
functions. Daily I have to clear the unlerying data tables and
repopulate with current data. I have the tools options set to manualy
calculate only yet every time my macro clears the data it recalcs then
every time one fo the 7 data tables is repopulated, it recalcs again.
What should be a fairly quick process is taking nearly half an hour
with the constsant recalculating.

Is there som instructions I can add to enforce the non-calculation
until I have populated all of the data and then trigger the
reclculation through an instruction?

Thanks in advance for your assistance.

Don Flak

What you described should be working...you might try adding this to the
beginning of your macro:

Application.Calculation = xlCalculationManual

And then at end:
Application.Calculate
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


" wrote:

I have some fairly large reports that utilize the SUMPRODUCT
functions. Daily I have to clear the unlerying data tables and
repopulate with current data. I have the tools options set to manualy
calculate only yet every time my macro clears the data it recalcs then
every time one fo the 7 data tables is repopulated, it recalcs again.
What should be a fairly quick process is taking nearly half an hour
with the constsant recalculating.

Is there som instructions I can add to enforce the non-calculation
until I have populated all of the data and then trigger the
reclculation through an instruction?

Thanks in advance for your assistance.

Don Flak

On Mar 31, 3:02*pm, Luke M wrote:
What you described should be working...you might try adding this to the
beginning of your macro:

Application.Calculation = xlCalculationManual

And then at end:
Application.Calculate
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*



" wrote:
I have some fairly large reports that utilize the SUMPRODUCT
functions. *Daily I have to clear the unlerying data tables and
repopulate with current data. *I have the tools options set to manualy
calculate only yet every time my macro clears the data it recalcs then
every time one fo the 7 data tables is repopulated, it recalcs again.
What should be a fairly quick process is taking nearly half an hour
with the constsant recalculating.

Is there som instructions I can add to enforce the non-calculation
until I have populated all of the data and then trigger the
reclculation through an instruction?

Thanks in advance for your assistance.

Don Flak- Hide quoted text -

- Show quoted text -

Luke,

This seemed to work but of course it left my calculation settings in
manual for every other report I ran after this. If I wanted to set it
back to automatic would it be as simple as
Application.Calculation=xlCalculationAutomatic?

Thanks,
Don