Pivot Chart and Formatting Lost

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

Original issue reported on code.google.com by arpitgo...@gmail.com on 21 Jun 2011 at 9:56

pearcefleming / excellibrary

Pivot Chart and Formatting Lost #98