https://bugs.documentfoundation.org/show_bug.cgi?id=159608
--- Comment #2 from ehar...@gmail.com --- More info on the related PivotTable problem: the PivotTable I recreated is already dead, after saving, closing, and re-opening the workbook. I am unable to click any of the drop down lists in the PivotTable, it functions like any other table. HOWEVER, I can right click and get to the PivotTable menu, so I clicked Properties and I can see that the Destination reference has changed. It is still to Selection and the cell is the same but again, the sheet name is the previous sheet in the list (the one positioned directly before this one). So I had entered and am looking at "$Felicia.$A$8" but now the PivotTable Properties read "$Levels.$A$8". These problems ALL follow a common pattern. Part of the references for PivotTables and for Charts are being replaced with the name of the previous sheet. -- You are receiving this mail because: You are the assignee for the bug.