Copying Pivot Table to new file--why does it still refer to original file?

  • Thread starter Thread starter LJones
  • Start date Start date
L

LJones

Hello,

I created a Pivot Table in an Excel file sent to me by a
co-worker. She sends a updated file each month with the
same layout, and I use the Move/Copy Sheet function to add
my Pivot Table to the new file.

The problem is, the table still points to the
consolidation ranges in the file I copied from. So, I
must manually redefine all the page fields to point to the
current file.

Is there any way around this?

Thanks!
LJ
 
You could record a macro that creates a pivot table from the ranges in
the active workbook.

Store the macro in Personal.xls, or another workbook that is always open.

Then, when you receive the new file, run the macro, and you'll have a
pivot table for the current data.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem copying pivot table 1
Rolling Forward Pivot Table Source Data 4
Move and Copy Pivot Table and Source Data 4
Pasted Pivot Table looks at old sheet 1
Are copied Pivot Tables "linked" to each other ? 2
Cannot Open Pivot Table Source File 0
Adding to an existing Pivot Table 7
Easy way to change Pivot table source files? 5

Back
Top