Does having several pivots on the main functional page slow it down?

[Myriad_Rocker]

I have an Excel report that has many pivots on it...probably 4 of them. It's quite slow functionally (drop down boxes that drive filters, etc). If I take those pivots off of the sheet and paste them onto another separate sheet, my wait times on drop downs decrease significantly.

So...is this something I should do? That is, move the pivots off the main sheet? Or is there something that I'm missing...like a caching issue or memory issue or something...something I could purge in code so it will run faster.

I should note that when you first open up the file...the first change you make to a drop down takes about a minute or more. After that, processing time decreases.

 

[Myriad_Rocker]

Bueller?