working with multiple workbooks

[mmmarks]

Hi,
I'm working with Data validation, Vlookup and other fuctions.
All function are working fine when I excuting them in a Active sheet. But now my query is..

I have a master file in D drive but it is not opened.
I want use data validation list in a new workbook and that List belongs to MASTER workbook.

Data validation is working when Master file is opened but not when its closed.
Is it possible to get data validated when master workbook is closed.
NOt only data validation but Vlookup also same.
When master file is opened Vlookup funcion working well but when master file closed it's not working .


Hope you all understood.

 

[Richard Schollar]

Hi

VLOOKUP should work even when the file is closed - is the Masterfile an Excel workbook (rather than a csv file, for example)?

Validation - you will need to import the valiues in the masterfile into a sheet of your workbook and then reference this imported range in your Validation. You could achieve this import via formulas eg

='C:\SomeFolder\[Masterfile.xls]Sheet1'!A1

and then point validation at this list.

 

[mmmarks]

Yes, as You said Vlookup is working fine when master file is closed

But @ data validation.

I'm doing like this..

I have a master file which is stored in C drive.

now I opend a excel file in D drive and doing as usuall

DATA VALIDATION I SELECTED LIST , THEN IN SOURSE I HAVE MENTIONED PATH OF MASTERFILE BUT ITS THROUGH "THE SOURCE CURRENTLY EVALUATES TO AN ERROR. DO YOU WANT TO CONTINUE"
WHEN I CLICK ON "YES".. I DIDNT GET DATA VALIDATIONS.
BUT WHEN I OPENED MASTER FILE ITS WORKING..