Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down menu's
I have created a s'sheet which has drop down menu's under each of the
headings to make it easier to collate information at the end of the week. Now that colleagues have started adding info onto the sheet it won't let me add more catogaries to my drop down menu's. When i click on 'DATA' the 'Validation' option is 'greyed out' anyone help? Lee |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down menu's
probably a shared workbook.
to make your changes, go to toolsshareworkbook double check you are the only one with it open then uncheck the box "allow changes by more than one user at the same time" it will resave now you can make your changes then you can go back and turn sharing on again (check the box) if you want -- Allllen "Lee" wrote: I have created a s'sheet which has drop down menu's under each of the headings to make it easier to collate information at the end of the week. Now that colleagues have started adding info onto the sheet it won't let me add more catogaries to my drop down menu's. When i click on 'DATA' the 'Validation' option is 'greyed out' anyone help? Lee |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop Down menu's
It is indeed a shared workbook mate, now sorted
thanks a lot for that Lee "Allllen" wrote: probably a shared workbook. to make your changes, go to toolsshareworkbook double check you are the only one with it open then uncheck the box "allow changes by more than one user at the same time" it will resave now you can make your changes then you can go back and turn sharing on again (check the box) if you want -- Allllen "Lee" wrote: I have created a s'sheet which has drop down menu's under each of the headings to make it easier to collate information at the end of the week. Now that colleagues have started adding info onto the sheet it won't let me add more catogaries to my drop down menu's. When i click on 'DATA' the 'Validation' option is 'greyed out' anyone help? Lee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Font Size in Drop Down Menu's | Excel Discussion (Misc queries) | |||
What do I need to change to get menu's to open when using Alt+(?) | Excel Discussion (Misc queries) | |||
Pull Down menu's | Excel Worksheet Functions | |||
Custom Menu's | Excel Discussion (Misc queries) | |||
Drop Down Menu's | Excel Discussion (Misc queries) |