Hey Domenic, do you have any good ideas on using an
INDIRECT function to specify a dynamic PivotTable Range
in the PivotWizard Range box. Been struggling with this
for awhile. I figure its impossible. That PivotWizard
range box just doesn't like a "!". It wants to change it
to ".xls!".

some backround? you add rows to the bottom of a range
which you wish to use as a PT range. If its in the same
sheet, the indirect function will work with a simple
refresh of the table. If its in a different sheet, it
fails.

I'm stumped.