Share via

Excel drop down list in another workbook

Anonymous
2022-01-31T17:15:31+00:00

I'm trying to have a list on one workbook and have another workbook get the list. All the videos I've seen reference "Name Manager" but there is no name manager in Excel 365 for Mac

I've tried a pivot table, data validation (this gives me an error message "This type of reference cannot be used in a Data Validation formula").

Microsoft 365 and Office | Excel | For business | MacOS

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

17 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-02-15T19:34:21+00:00

    and then I get this again:

    0 comments
  2. Anonymous
    2022-02-16T04:58:50+00:00

    Hi David,

    In this screenshot you have, it lack of a plus symbol. Use data validation with value "= MasterListInstlnit"

    Regards,

    Rena

    0 comments