Hi JW.

You can simply go to your pivot table, go to the wizard, and go back
to your source data.
Change the directory there to reflect where your data source is..
This should do the trick.

You owe me a Krystal when you get your first million!

:)