| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Validation not working in shared file
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation not working in shared file
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation not working in shared file
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation not working in shared file
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Validation not working in shared file
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation has stopped working on one paricular sheet only | Excel Worksheet Functions | |||
| Data Validation not working!! Please help!!!! | Excel Discussion (Misc queries) | |||
| Macro not working properly when the file is shared | Excel Worksheet Functions | |||
| How not to lose data when working on the same shared document? | Excel Discussion (Misc queries) | |||
| Data Validation Not Working | Excel Discussion (Misc queries) | |||
Hybrid Mode
