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

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
 
D

Debra Dalgleish

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.
 
Top