Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2
Default Pivot table error when Opening an Xml Spreadsheet from MS excel Xp

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?

Please advise a forum to which i can submit the above question.

Thanks and Regards,
Jagadeesan
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Improvements in Excel Pivot Table Access4Afghan Excel Discussion (Misc queries) 5 February 12th 06 03:41 PM
Excel 2K3: Opening a spreadsheet, also opens book1.xls? Newtek Excel Discussion (Misc queries) 3 July 6th 05 07:56 PM
Pivot Tables, Help? Adam Excel Discussion (Misc queries) 6 March 24th 05 03:35 PM
Pivot Table Problems Rachel Gonsior Excel Discussion (Misc queries) 3 March 21st 05 08:24 PM
Problems with Pivot Table Field Sorting in Excel 2002 Phoenix71555 Excel Discussion (Misc queries) 1 February 28th 05 12:25 AM


All times are GMT +1. The time now is 03:47 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"