What steps will reproduce the problem? 1.Add Pivot Table and Pivot Charts from Table Data 2.Open Excel File through this 3.Save any cell of any sheet with different value. 4.All Pivot Table and Pivot Chart lost and sheet comes to compatible mode.
What is the expected output? What do you see instead? Sheet Should have existing Charts and Table on Sheet and they should be updated with new value.
What version of the product are you using? On what operating system? Product Version 1.0.0.0 Date Modified 4/14/2011
Please provide any additional information below.
Sheet ReportData contains data which need to update and other sheet contains its pivot report. As Data is Updated and saved all report should be updated. I am able to clear the ReportData Sheet and Fill the Data, but on saving all reporting will lost. No charts and appropriate data will be there in report sheets.
Please Help.
Thanks Arpit
Status: New
Labels:
Type-Defect
Priority-Medium