Why not combine the workbooks so that you have a source sheet and a
destination sheet - no problem with external references then.

Hope this helps.

Pete

On Aug 19, 6:11*pm, Ravi wrote:
Hi All,

I am facing one problem, appreciate someone could solve this.

I created 2 different workbook .One is destination and other is source. Now
I have written formula to get values from source workbook. It works fine in
my local system. but when I copy paste these workbook in some other location
so my formula does not work bcoz cell could not get the path of source
workbook since location is changed.

This sounds very weird that every time I have to manually edit the links. I
tried using edit link property and tried to change source location. But cell
get error #refe 'invalid cell reference'.

Is there anyway to define generic path in formula so that wherever I place
my workbook and formula would pick right path automatically.