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
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