Hi Abhishek,
Did you try giving the complete path to the cell references directly?
like ='C:\DOCUME~1\PKARAN~1\LOCALS~1\Temp\notes327EC1\[Training
curriculum.xls]Sheet3'!$A$82
You can give the complete pathto the location of your masterfile directly.
Let me know if this works.
Regards,
Praveen
Hi everybody,
I'm facing a problem in updating data in two separate workbook can
anyone help me in this ?
I have 2 excel files one is Master file and other is the snapshot
file. All the working are done in the master file and in the snapshot
file all the different scenarios are show, in which val
