“Not sure if this is the correct place to report an issue or not, however I could not find any other so posting.
Excel 2013 - Click to run installation - verion 15.0.4797.1003
Insert a Table
Create a Name Range referring to one of the columns in the table
Create a In cell data validation and choose List - put in the named range and click ok.
Now you can see the table column contents in the in cell drop down.
Previously this method used to work with Form Controls ComboBox as well as ActiveX controls.
After the latest udpate - this has stopped working.
So if you put in a Named Range in the Form Control properties, put in the Linked Cell referrence and use TAB key to navigate in the dialog box; you will see the table selected when you highlight the
INPUT RANGE, however the drop down will not show after you have come out of the box by clicking on OK.
All other setting will be saved just the Input range is not getting saved - only when using a Named Range.
Hopefully i have tried to explain the issue and will be happy to provide any sample files also if needed.