Data validation

Copper Contributor

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 worksheet but this one doesn't work) is =dropbox!A1:A10. I receive an error saying it's not a valid reference. Change the reference to a single cell, or use the reference with a worksheet function such as =SUM.

 

This worked in a previous spreadsheet, why won't it work here?

 

4 Replies

@Karin5281 "dropbox" is a tab on the worksheet it is trying to access. =dropbox!A1:A10 is referring to cells A1-A10 on the "dropbox" page.

@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.

@Karin5281  that error message sounds a lot like this case:

mtarler_0-1609781209676.png

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?

@mtarler that worked! Thank you so much.