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.

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.

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" wrote:

> 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.

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,
--
Pranav Vaidya
VBA Developer
PN, MH-India
If you think my answer is useful, please rate this post as an ANSWER!!


"Mark" wrote:

> 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" wrote:
>
> > 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.

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

"Pranav Vaidya" wrote:

> 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,
> --
> Pranav Vaidya
> VBA Developer
> PN, MH-India
> If you think my answer is useful, please rate this post as an ANSWER!!
>
>
> "Mark" wrote:
>
> > 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" wrote:
> >
> > > 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.