|I am using Excel 2010 in compatability mode for Excel 2003. I have a dependent drop-down list that works correctly. When I go to save it, I get "Significant loss of Functionality" message, and when saved, the list no longer works.|
In spreadsheet EMP cell B6, I have a drop-down list titled "title" which is composed for four cells: 'blank', CL, HN, and FI.
In spreadsheet REMP cell F10, I have "indirect(emp!b6) which produces the correct down-drop list until saved.