Deactivate a Pivot Table

[jcbcmc]

Hi,

Is there anyway to keep a pivot table in an Excel worksheet, but have it deactivated when not using so it does not slow down the entire file? I would rather not have to rebuild it each time if there is such an option.

Thanks for any help or suggestions!

 

[Robert Mika]

Pivot will not recalculate unless you refresh your data manualy or have the option "Referesh Data when opening the File" ON