Using Excel 2016.
Searchable DD list works fine until I protect the sheet, once I protect the sheet it doesnt.
Thanks,
VinceF
Searchable DD list works fine until I protect the sheet, once I protect the sheet it doesnt.
Thanks,
VinceF
Amanda, Thank you for your reply,
I'm not sure why this would be an issue...it seems to me that one should be able to protect the sheet and still have the searchable DD list working.
Never-the-less, Both the cells with the DD list and the cells where the list references too are all unprotected/unlocked. So, as you wrote "...the Searchable DD list available as long as the cells where you apply the feature are unlocked", am I misreading this or missing something?
Thanks,
VinceF
Excel 2016
The new version should be launched in two or three months. Note that this is an estimated timeThanks again for the reply and clarification. Do you have an approximation as to when the updated version will be released?