Range 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

Similar Threads

Reference is not valid 0
Embedded Excel into Word with Tables 0
Excel 2007: "Reference is not valid" when refreshing pivot table 2
Changing pivot table ADO recordset 0
Excel 2013 Pivot Data Range formula reference problem 0
DYNAMIC RANGE FOR PIVOT TABLE 1
Please help! Cannot open pivotTable source file.... 2
Prevent range reference 3

Top