Excel Pivot Tables

[Mandy]

I have been able to reduce the file size by unclicking
the option "save data in pivot table". I can't seem to
find an article on the web that will explain to me if I
will lose functionality of the pivot table if I turn this
option off.

Can you help?

 

[Debra Dalgleish]

As answered at your other post:

You won't lose the functionality, but it may take longer to refresh the
data. There's information in the following MSKB article:

How to optimize PivotTable performance in Excel 2000
http://support.microsoft.com/default.aspx?id=273583

 

[Mandy11]

Thanks, that article was very helpful