I have a spread sheet that every once in while won't open. Excel trys to recover it and removes all the pivot tables. Its happened a few times now. The pivots aren't complicated, there are no calculated fields and the source data is ~5k rows * 20 columns no complicated formulas just small range xlookups and basic if statements.
any ideas what causes this kind of error.
Removed Part: /xl/pivotTables/pivotTable6.xml part. (PivotTable view)
Removed Part: /xl/pivotTables/pivotTable7.xml part. (PivotTable view)
Removed Part: /xl/pivotTables/pivotTable7.xml part. (PivotTable view)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable7.xml part (PivotTable view)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable11.xml part (PivotTable view)
Repaired Records: Cell information from /xl/worksheets/sheet6.xml part
any ideas what causes this kind of error.
Removed Part: /xl/pivotTables/pivotTable6.xml part. (PivotTable view)
Removed Part: /xl/pivotTables/pivotTable7.xml part. (PivotTable view)
Removed Part: /xl/pivotTables/pivotTable7.xml part. (PivotTable view)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable7.xml part (PivotTable view)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable11.xml part (PivotTable view)
Repaired Records: Cell information from /xl/worksheets/sheet6.xml part