Hi,

I have a query in sheet called Source Data. In sheet called Created Pivot I
have pivot. Because I want to reuse the pivot I use a named reference. Excel
"automatically" designates the name 'newreport' to the data range in sheet
Source Data. When I declare that name in the pivottable wizard, I get
message; reference is not valid. How do I refer to the query then?!

Regards,

Basta