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.