Problem copying pivot table

L

LJones

Trying again:

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.

I need to automate this. Can someone help me?

Thanks!
LJ
 
A

Al

if i am making sense of what you're saying---try doing it
the opposite way--instead of copying your pivot table to
the new data..copy the data to a sheet in the file where
your pivot table is.
 
Top