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 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?

 

excel

4 Replies

  • rhancock's avatar
    rhancock
    Brass Contributor
    Jan 04, 2021

    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.

    • 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?

Resources