PivotTable saved without underlying data (XL97)

CoreenT · Apr 1st, 2002, 12:41 PM

How can I make sure my pivot tables are saved WITH underlying data.
Sometimes I get the following message when trying to use my pivot tables:
"PivotTable saved without underlying data. Use the Refresh Data command to update the PivotTable."
I cannot figure out why some of my pivot tables ARE saved with the underlying data and some ARE NOT.
(I am aware of the "Refresh on open" setting but am still hoping for an answer to the above.)
Please help.
Coreen

dk · Apr 1st, 2002, 01:22 PM

If you right click the pivot table and choose Table Options. There is an option Save Data with Table Layout in the data source options. That needs to be checked.

HTH,
D

CoreenT · Apr 1st, 2002, 01:25 PM

Thank you very much, DK. That solved my problem! (^_^)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 1st, 2002, 12:41 PM	#1
CoreenT New Member Join Date: Mar 2002 Location: Irvine CA Posts: 2	How can I make sure my pivot tables are saved WITH underlying data. Sometimes I get the following message when trying to use my pivot tables: "PivotTable saved without underlying data. Use the Refresh Data command to update the PivotTable." I cannot figure out why some of my pivot tables ARE saved with the underlying data and some ARE NOT. (I am aware of the "Refresh on open" setting but am still hoping for an answer to the above.) Please help. Coreen

Apr 1st, 2002, 01:22 PM	#2
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	If you right click the pivot table and choose Table Options. There is an option Save Data with Table Layout in the data source options. That needs to be checked. HTH, D

Apr 1st, 2002, 01:25 PM	#3
CoreenT New Member Join Date: Mar 2002 Location: Irvine CA Posts: 2	Thank you very much, DK. That solved my problem! (^_^)