Share via

Drop-down lists don't save...

Anonymous
2011-03-19T17:30:08+00:00

I have several drop-down lists in an Excel 2010 workbook, and they all work fine, except for the last few I have created.  These new ones work fine after I create them, but after I save, close, and re-open the file, they are gone, as if I never created them.  What's going on here?  Thanks!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2011-03-19T19:29:06+00:00

Exactly how are you creating them?....Can you post the steps?

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-03-19T19:42:43+00:00

    I found a solution, but I don't know why the problem ever started.  I created the drop-down lists in the typical way: highlight the cell, choose "Data Validation," Allow List, choose the source for the drop-down list. 

    I had to Save-As, and choose "workbook with macros enabled."  I don't know why, because all the earlier drop-down lists continued to work.  And I don't know how my workbook ever transformed from one form to the other anyway.

    I think better documentation by Microsoft is in order here.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments