Pivot table in Xml Spreadsheet

J

Jagadeesan

Hi,

I have saved an excel file as an xml file that has a pivot table. When i
open the same xml spreadsheet again in excel and click on the pivot table, it
gives me the error as below.

"This pivot table report is not valid"

But it works when i refresh data for the pivot table. Hence, I have to
refresh the data every time i open the xml spreadsheet to make the pivot
table working. Is there any way to make the pivot table working without
refreshing the data?

Regards,
Jagadeesan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top