redefine the validationlists...that may help
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Mark" wrote:

I created dropdown lists in an Excel 2003 file located on a Windows XP
intranet.
The lists reference to a different worksheet, and work fine from within the
file.
However I would need to share the same dropdown lists with other users,
within a shared file on the same network.
I've tried to unshare the file temporarily, I pasted the two worksheets in
the file (the one with the dropdowns and the one containing the data
referenced to as names), then shared the file again.
The dropdown lists don't work in the shared file.
Can anyone advise what I'm doing wrong or how to work around this issue?
Thanks in advance.