Radha

One way is to type the whole path/address of the file and relelvant
sheet/cell reference:

like

='C:\Documents and Settings\User\Desktop\[Wars.xlsx]Sheet1'!$B$34


"Radhakant Panigrahi" wrote:

hello is there any way to find a specific value in excel file which is not
currently not opened howeveranother excel file is open...so is there any
wayout to find by giving any command...

Regards,
radha