Just a thought for a quick check
(but I think Anne's response would have nailed your issue) ..

In a new sheet,
Select A1, then click Insert Name Paste Paste list
Check the pasted list for any errors in the defined names,
eg: =#REF!$A$1:$B$1

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"quilting2" wrote:
i am new to excell and i have a document that i got from work that has
multiple worksheets, that drop down in the "name box" it says i get them but
i cannot get back to my original document.. sorry dont know how else to
describe this. thanks T