View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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.