Share via

I can't use table as source in data validation

Anonymous
2022-08-12T08:09:54+00:00

My excel is 2021 version and when I tried to use table as source, there's windows pop up saying there's problem with formula

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

7 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Rory Archibald 18,885 Reputation points Volunteer Moderator
    2022-08-12T09:01:56+00:00

    You can't use table names or structured references in DV. Either select the column you want (it will auto expand if the table does even though you get a fixed reference in the DV source box) or define a name that uses the table/column name and then use the name in the DV dialog.

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments
  2. Anonymous
    2022-08-12T11:16:48+00:00

    Hi, thank you for your response, I just looking up for more ways to do it, and it turns out that I can choose table name if I click F3 (there'll be list of table name), and it works

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  3. Rory Archibald 18,885 Reputation points Volunteer Moderator
    2022-08-12T09:02:32+00:00

    That would just give a dropdown with the word Produce in it.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  4. Anonymous
    2022-08-12T11:38:22+00:00

    Hello Wara_397,

    I am glad we were able to assist you!

    Best Regards, Asher

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  5. Anonymous
    2022-08-12T08:43:12+00:00

    Hi Wara_397,

    Thank you for reaching out to us today. I’m Kevin and I’m happy to to help you out with your question today.

    Please try removing the = from before Produce, assuming that Produce is a valid reference within your sheet?

    I hope this information is helpful. If you have any further questions or need additional assistance, please reach back out and I will be more than happy to assist you.

    Best Regards, Kevin

    Give back to the Community. Help the next person who has this issue by indicating if this reply solved your problem. Click Yes or No below.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments