Currently having trouble with opening a document I've added several Pivot Tables to. I've did similar work to another document a few weeks before and that continues to run without issue, being updated on a daily basis. This new document is layed out nearly identically and everything is formatted to how I want, as this worked on the last document I did the same work to.
Everytime I've tried to open the new document since I added the Pivot Tables, the following messages appear:
"We found a problem with some content in 'TRACKER NAME HERE'. Do you want us to try to recover as much as we can? if you trust the source of this workbook, click Yes." I click Yes else the doocument won't open and 5 minutes later after trying to recover the workbook, the document opens with the following messages in a pop-up:
Removed Feature: PivotTable report from /xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable2.xml part (PivotTable view)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable3.xml part (PivotTable view)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable4.xml part (PivotTable view)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable5.xml part (PivotTable view)
Removed Records: Workbook properties from /xl/workbook.xml part (Workbook)
I can't work out why this keep happening. I've copied the data over to new workbooks a couple times and done all the work again to see if that works, but the same messages appear. I'm left with the sheets where the Pivot Tables were, with the data but no Pivot Table features to update/refresh etc.
Does anyone know why this might be happening? As when I did the exact same work to the last document, there have been no issues.
Or is this something related to internal functionality and should, therefore, contact my IT department?
(I apologise for lack of knowing terminology etc, my excel skills are very basic and what I know I taught myself)
Everytime I've tried to open the new document since I added the Pivot Tables, the following messages appear:
"We found a problem with some content in 'TRACKER NAME HERE'. Do you want us to try to recover as much as we can? if you trust the source of this workbook, click Yes." I click Yes else the doocument won't open and 5 minutes later after trying to recover the workbook, the document opens with the following messages in a pop-up:
Removed Feature: PivotTable report from /xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable2.xml part (PivotTable view)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable3.xml part (PivotTable view)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable4.xml part (PivotTable view)
Removed Feature: PivotTable report from /xl/pivotTables/pivotTable5.xml part (PivotTable view)
Removed Records: Workbook properties from /xl/workbook.xml part (Workbook)
I can't work out why this keep happening. I've copied the data over to new workbooks a couple times and done all the work again to see if that works, but the same messages appear. I'm left with the sheets where the Pivot Tables were, with the data but no Pivot Table features to update/refresh etc.
Does anyone know why this might be happening? As when I did the exact same work to the last document, there have been no issues.
Or is this something related to internal functionality and should, therefore, contact my IT department?
(I apologise for lack of knowing terminology etc, my excel skills are very basic and what I know I taught myself)
