Problem copying pivot table

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

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.
-----Original Message-----
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

.