I am running into a bizarre error in Excel that I am hoping someone can help me with.
I have a macro-enabled workbook created in excel 2010. On the workbook are a series of radio buttons. When a radio button is selected, I use the selected value to populate a data validation list in another part of the spreadsheet. So, for example, I select the radio button for "Division 1" and that populates a list of regions specific to Division 1 and so on.
Each set of regions has a named range. The data validation list uses the INDIRECT formula to substitute a range name dependent on the selected radio button.
This works fine in Excel 2010. However, when I run the same file in Excel 2007, I do not get the dropdown list in the validation cell. I've followed all the troubleshooting steps outlined in the Contextures blog about disappearing dropdowns in validation lists but none of those have solved the problem.
Any ideas as to what might be going on?