Data Validation not working in shared file

[Mark]

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.

 

[Pranav Vaidya]

redefine the validationlists...that may help

 

[Mark]

Hi Pranav,
thanks for your suggestion.
I had already tried to redefine the lists: but from within the shared file
the "Validation" entry in the "Data" menu is grayed out.
Is there any other way I could redefine the lists other than selecting Data
- Validation?
Thank you in advance!
Marco

 

[Pranav Vaidya]

To the best of my knowledge, you can not use validation in a shared file. To
redefine, you will have to remove the share, redfine the list and share the
file again.

HTH,

 

[Mark]

Thank you for your further reply Pranav.
Unfortunately I had already tried to remove the share, redfine the list and
share the
file again.
However, if I do that, clicking the cells that used to be referring to the
dropdowns simply display a downward arrow, but the list is empty.
It's as if I had to redefine the lists again.
Only I cannot do that because the file is shared.
It's a vicious circle and it seems there is no solution... ?
I will rate your answer as useful because it seems to explain that
validation in an Excel shared file is not possible, although it does not
solve my problem.
Thank you anyway,
Mark