Aug 08 2021 09:32 PM
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".