Data validation

%3CLINGO-SUB%20id%3D%22lingo-sub-2029872%22%20slang%3D%22en-US%22%3EData%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2029872%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20recreate%20a%20data%20validation%20that%20works%20in%20a%20different%20workbook.%20I%20have%20a%20column%20of%20data%20on%20a%20separate%20worksheet%20titled%20dropbox.%20My%20data%20validation%20formula%20(which%20is%20the%20same%20as%20the%20other%20worksheet%20but%20this%20one%20doesn't%20work)%20is%20%3Ddropbox!A1%3AA10.%20I%20receive%20an%20error%20saying%20it's%20not%20a%20valid%20reference.%20Change%20the%20reference%20to%20a%20single%20cell%2C%20or%20use%20the%20reference%20with%20a%20worksheet%20function%20such%20as%20%3DSUM.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20worked%20in%20a%20previous%20spreadsheet%2C%20why%20won't%20it%20work%20here%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2029872%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2029909%22%20slang%3D%22en-US%22%3ERe%3A%20Data%20validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2029909%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F917346%22%20target%3D%22_blank%22%3E%40Karin5281%3C%2FA%3E%26nbsp%3B%22dropbox%22%20is%20a%20tab%20on%20the%20worksheet%20it%20is%20trying%20to%20access.%20%3Ddropbox!A1%3AA10%20is%20referring%20to%20cells%20A1-A10%20on%20the%20%22dropbox%22%20page.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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.