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