Solved Is there a drop-down list work-around?

Microsoft Excel 2003 (full)
February 20, 2012 at 12:50:56
Specs: Windows XP, 1.0Gb
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.

Thank you.
Brian W

See More: Is there a drop-down list work-around?

Report •

February 20, 2012 at 15:30:48
✔ Best Answer
re: In spreadsheet REMP cell F10, I have "indirect(emp!b6)

I assume you mean that in REMP!F10 you have a Data Validation list.

Try giving emp!b6 a Name and then refer to that name instead of using emp!b6 inside your INDIRECT function.

A Google search turned that up as a solution and it seemed to work for me.

As much as I don't mind answering questions, you might be able to save yourself some time if you Google your symptoms instead of waiting for an answer in a forum.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

February 20, 2012 at 18:01:15
Dear DerbyDad03,

Thank you for your response; I did Google before I sent a question to the forum but I was unable to figure out an appropriate response. Your suggestion of using a name worked.

Thank you.
Brian W

Report •

Related Solutions

Ask Question