Data Validation with linked File

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

is there a way to do a data validation to a seperate spreadsheet that is not
open. I have been able to do the validation to the spreadsheet but it must
be open to work. The spreadsheet is very large and i would perfer to keep it
closed.

or Could i do a data validation to an Access table?
 
You'll have to link a range of your workbook to the closed file or
import data from the access table, and then use that range for the data
validation.
HTH
Daniel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Data List 2
Data Validation Error 1
Validation list in data entry form 4
Data Entry + Validation 3
Data Validation 1
Data Validation Dropdown List Not Working 4
Data Validation List will not Fill Down 3
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0

Back
Top