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