Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference is not valid
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink - reference not valid | Excel Discussion (Misc queries) | |||
Sort reference is not valid | Excel Programming | |||
'reference is not valid' | Excel Discussion (Misc queries) | |||
hyperlink reference not valid | Excel Worksheet Functions | |||
Reference is not valid | Excel Worksheet Functions |