Error while opening Pivot Table saved in XML Format

Asked By Jason Baiteman 50 points N/A Posted on - 02/28/2013

 

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.

• Status: Open
• Question Views: 846
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Drake Vivian 30 points N/A #144997

Error while opening Pivot Table saved in XML Format

 

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

• Vote Up 0 Vote Down

• Posted on - 03/21/2013
• Question Category: MS Excel