Copied Pivot table links always to original

JM_pt

New Member
Joined
Aug 31, 2020
Messages
1
Office Version
  1. 2016
Platform
  1. Windows
Hello all,

I want to make a sheet template, in which there is a normal table (source of data) and a pivot table.
I need to make a lot of copies of this template to work on them.

But the new copies of the pivot tables are always linked to the normal source table of the original. How can avoid this?

Even If I change the data source of the "pasted" sheet pivot table, it is a huge mess, because it will also change the source of data of the original sheet!

Making isolated excel files with the template sheet, and then duplicating them from windows explorer, kind of works (then I copy the sheet to my workbook). But, it is still annoying because I have to manual re-select the source of data every time


Any idea? (it´s 2016)
 

Some videos you may like

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.

rondeondo

Board Regular
Joined
Aug 15, 2012
Messages
156
Hi There

I do something similar to what you describe. I have a template file that I open then save as a new file, the pivot then refers to the relevant table in the new file. If you copy a sheet from one file to another the formulas tend to stay referring to the source file. This is very frustrating.
As a side note, if you copy a sheet to a new table, or a set of formulas to a new sheet you can use search & replace to take the file name out of the formulas.
 

Watch MrExcel Video

Forum statistics

Threads
1,114,510
Messages
5,548,488
Members
410,840
Latest member
Kar3ousse
Top