Error while opening Pivot Table saved in XML Format

Asked By 50 points N/A Posted on -
qa-featured

 

Hello,

I have created a pivot table and saved it in an excel file in xml file format. It creates problems when I open it again giving me an error message like the one- "This pivot table report is not valid". It works again when I refresh those data of the pivot table opening the xml file. Is there any solution of this so that I can open the xml file and make it work without refreshing those data of the pivot table?

Thanks.

  • Answer Accepted: No
  • Question Category:
SHARE
Answered By 30 points N/A #144997

Error while opening Pivot Table saved in XML Format

qa-featured

 

Hello there Jason,
 
Unfortunately, the answer to your question would be – no, you can't avoid refreshing the reports. All reports based on non-OLAP source data that were saved as a Web pages need to be refreshed at your first try to use them in order to work correctly. This is necessary because your fields in the source data contain more than one type of data (i.e. Text and numbers).
 
The only workaround to avoid refreshing your Pivot reports is to keep your fields clean and with only one type of data. 
 
Best regards,
Drake Vivian
About Drake Vivian
Questions
0
Answers
820
Best Answers
186
  • Posted on -
  • Question Category:

How to convert Windows emf to Mac pict?

Previous

Error appears while saving portion of custom filter view in Java Script

Next

Related Questions