Issue with a dynamic dropdown - secondary value not displayed

Copper Contributor

OS:  MS Windows 10

Excel version 1908 Build 11929.20946

 

I've built a dynamic drop down menu with the following values in a table named "Expense _Category_List"

 

Payments
Reprints/Education Materials

 

If a user selects Reprints/Education Materials the next dropdown should dynamically display the value "Reprints/Education Materials", however it's not working.  The second menu will not display any values.

 

In Name Manager I have an entry named "Reprints" that refers to Table 37[Reprints/Educational Materials]

 

I think the issue is with the '/' in the Expense_Category_List value but I'm not sure.  I cannot rename this value to anything else because there are other functions that are depending on receiving this value as named.  Is there anything I can do?

 

I have a feeling this is because of the "/" in the name of the value "Reprints/Education Materials".  

0 Replies