Forum Discussion

Karin5281's avatar
Karin5281
Copper Contributor
Jan 04, 2021

Data validation

I'm trying to recreate a data validation that works in a different workbook. I have a column of data on a separate worksheet titled dropbox. My data validation formula (which is the same as the other...
excel
Karin5281's avatar
Karin5281
Copper Contributor
Jan 04, 2021

rhancock Yes, I know that part. But why won't that work as the source for my data validation? It kicks back an error message.

mtarler's avatar
mtarler
Silver Contributor
Jan 04, 2021

Karin5281  that error message sounds a lot like this case:

The problem here is that the 'Allow' is set to 'Custom' instead of 'List'

If this isn't your problem, can you share the workbook?

  • Karin5281's avatar
    Karin5281
    Copper Contributor
    Jan 04, 2021

    mtarler that worked! Thank you so much.

Resources