specific excel doc no longer add dropdowns
I am using Excel 2003 with sheets 1 & 5 using the dropdown. Sheet 6 is where
the dropdown data is located. The dropdowns in sheet 5 are working but I lost the dropdowns in sheet 1 and I cannot seem to add them back. I have tried removing the "Name", adding is back and validating again but that did not work work. This document is often saved as a shared workbook but in order to create dropdowns you have to unshare. I also had auto-filters on sheets 2-4 and I took them off (even though they are not using the dropdowns) thinking maybe there was a problem with that function. I have also done a detect and repair and that did not help. This workbook is not protected. What am I missing? thanks! |
specific excel doc no longer add dropdowns
I am assuming you are referring to Data Validation, and you are using
a named range as the list? |
specific excel doc no longer add dropdowns
correct, I am using a named range with data validation.
I tried to create a dropdown on a new workbook and I dont have any issues. "damorrison" wrote: I am assuming you are referring to Data Validation, and you are using a named range as the list? |
All times are GMT +1. The time now is 05:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com