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

Reproduce the issue using an Excel file with a ReportData sheet, a pivot table, and pivot charts: open it, change and save a cell, then inspect the report sheets. Confirm whether saving in the library's Excel file-format handling removes the pivot tables, charts, formatting, or compatible-mode metadata; done means the existing reports remain present and reflect the updated data.

Written by the indexing model from the issue text.