Modifying Data in Drop Down Menu
Hi,
I've created a spreadsheet with multiple drop down menus (data located on a separate worksheet within same file). I modified some of the drop down menu data but it's not being recogized. Any suggestions ? Thank you. |
Modifying Data in Drop Down Menu
When you sday you modified data... did you add rows? Or just change what was
in there? Go to Insert Name Define... and check the range for the list(s) you have modified. Does the name encompass all records? "GooseMA" wrote: Hi, I've created a spreadsheet with multiple drop down menus (data located on a separate worksheet within same file). I modified some of the drop down menu data but it's not being recogized. Any suggestions ? Thank you. |
Modifying Data in Drop Down Menu
What did you modify?
Did you add more items to the list? If so, you have to re-define the list references in InsertNameDefine to include the added items. Gord Dibben MS Excel MVP On Fri, 22 May 2009 07:54:10 -0700, GooseMA wrote: Hi, I've created a spreadsheet with multiple drop down menus (data located on a separate worksheet within same file). I modified some of the drop down menu data but it's not being recogized. Any suggestions ? Thank you. |
All times are GMT +1. The time now is 09:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com