Guybrush Threepwood
New Member
- Joined
- Apr 21, 2012
- Messages
- 13
- Office Version
- 365
- Platform
- Windows
Hi all.
I have an Excel 365 workbook with pivot tables which is saved in a Sharepoint location. When I make a copy of this workbook to another location (either within Sharepoint or locally) all the pivot tables in the copy reference the sharepoint location of the original workbook instead of the data table in the copy.
Obviously I can update the pivot table source in the copy, but this is pain staking work when you have about 30 workbooks with 16 pivot tables in each.
Does anyone know how to prevent the copy from referencing the original workbook?
Many thanks.
I have an Excel 365 workbook with pivot tables which is saved in a Sharepoint location. When I make a copy of this workbook to another location (either within Sharepoint or locally) all the pivot tables in the copy reference the sharepoint location of the original workbook instead of the data table in the copy.
Obviously I can update the pivot table source in the copy, but this is pain staking work when you have about 30 workbooks with 16 pivot tables in each.
Does anyone know how to prevent the copy from referencing the original workbook?
Many thanks.