You can't tell if the macros are causing the problem. It doesn't matter if
they are event driven or not event driven. If the are UDF functions then
they may make a difference. For example if you have the Date() function on
you workbook. Everytime the book is opened your workbook the sheets will be
recalculated and the UDF functions will get executed.

"Harry" wrote:

Hey all:

I have a workbook that takes 2 minutes to open once I enable macros.
The macros are not workbook event driven (they are unrelated to the problem).

I think the problem stems from an excessive # of pivot tables and pivot
charts. I have 25 pivot tables, all using the same source data (the data is
sliced and diced in different ways).

I am also using a lot of database functions (DAVERAGE, DCOUNT, DCOUNTA) but
I don't think this is adding to the problem.

I am using a few functions from the analysis toolpack (NETWORKDAYS is the
big one). The analysis toolpak is showing up as an external link (user is
prompted to update links when workbook is open).

Finally, I have a lot of VLOOKUPS that are essential to pulling data and
putting it into charts,

Can anyone offer some guidance? I am looking at knocking down the workbook
opening time (2 minutes is too long).

thanks,
Harry