Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - Reference is not valid
I have a list in a file name abc.xls. I have defined the list with a
name say XYZ. I have another file Summary.xls with a pivot table that I'm using to give me a summary of that list. The 'XYZ' which is the defined name of the actual list in abc.xls file works when both the files are open. When I open the Summary.xls file, first message says "Reference is not valid" and second message says "Cannot find "abc.xls file". If I first open the abc.xls file and then the summary.xls, then it works and not viceversa. Please update. Thx. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table - Reference is not valid
You have multi-posted this to five newsgroups, you have an answer in misc.
Please only post once and carefully where the question in relevant, say ..misc. At least post once to a couple of groups so the threads stay together -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England DTHIS web: www.nickhodge.co.uk blog: www.nickhodge.co.uk/blog/ FREE UK OFFICE USER GROUP MEETING, MS READING, 27th APRIL 2007 www.officeusergroup.co.uk "Sinner" wrote in message oups.com... I have a list in a file name abc.xls. I have defined the list with a name say XYZ. I have another file Summary.xls with a pivot table that I'm using to give me a summary of that list. The 'XYZ' which is the defined name of the actual list in abc.xls file works when both the files are open. When I open the Summary.xls file, first message says "Reference is not valid" and second message says "Cannot find "abc.xls file". If I first open the abc.xls file and then the summary.xls, then it works and not viceversa. Please update. Thx. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Pivot Table: Why reference is not valid ? | Excel Discussion (Misc queries) | |||
what does "data source reference is not valid' in Pivot table | New Users to Excel | |||
Pivot Table - Reference is not valid | Excel Worksheet Functions | |||
Pivot table - Reference is not valid | Excel Discussion (Misc queries) | |||
Pivot Table - Reference is not valid | Links and Linking in Excel |