I can't use table as source in data validation

Question

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

Answer 1

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.

Answer 2

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.

Answer 3

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

Answer 4

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

Answer 5

hi, produce is my table's name, thank you for your response