Checked out the site, Dave. I think I used to have similar problems with
Office 97 and I thought it was due to the data being on another sheet. Ever
since I change that I had no more problems. I think too that naming ranges
tends to slow down calculations, but again that was on an early version.
Maybe the later versions handle this better and I'll test that for sure.

Rob

"Dave Peterson" wrote in message
...
Check out Debra Dalgleish's site:
http://contextures.com/xlDataVal01.html#Name

Then you can test it.

Rob wrote:

Well you may be right, but I'm not convinced. I just have a memory of
reading in previous newsgroup answers that this was a problem.

Rob

wrote in message
ups.com...
Shouldn't matter if i'm calling it by defined name



On Apr 18, 2:26 am, "Rob" wrote:
I'm not an expert and others may advise better, but I think having
your
data
on another workseet may be the problem

Rob

wrote in message

ups.com...

This was working fine a few minutes ago then all the sudden it
stopped. None of the drop down lists are working. I have multiples
set
up on a sheet. some are accessed locally on the sheet and some draw
from another sheet in the workbook using =Address1 as the Name. But
I
can't get any of them to work now! Please Help I have to finish this
project tonight!!!



--

Dave Peterson