| Home |
| Search |
| Today's Posts |
|
#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. |
| 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) | |||
Threaded Mode
