Reference is not valid

B

Basta1980

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top