I am using the validation option for a list located in another workbook (called ratings). There is a primary list and an indirect list used in another workbook based on the list located in the ratings workbook. The validation list works fine when the ratings workbook is open, however, it does not work when the workbook is closed. Is there a way the validation option can still operate even when its using a list from a closed workbook. If not, what would be the best way to go about pulling a list from a workbook that does not have to be open. I am also defining some names off that workbook (thus using the primary and indirect lists on the current workbook). Might that also have anything to do with not being able to pull the list off of the closed workbook. Thanks and look forward to the responce.