Have you tired ='C:\My Documents\excel\[source.xls]Sheet1'!$A$1
If both files are open this should work
If 'destination' is closed, it will update next time you open it
Try it and tell us the result
VLOOKUP does not seen appropriate here
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"Kanmi" wrote in message
...
I'm working on Excel file called destination.xls then i want to call up
another workbook source.xls to automatic update destination.xls on some
rows.
I mean whenever source.xls change then destination.xls should pull
automatic
update from it. I taught of using ='C:\My
Documents\excel\[source.xls]Sheet1'!$A$1 OR VLOOKUP FORMULAR .

"NOTE" If i change anything in those rows in source.xls then it should
automatically change the same rows in destination.xls. Please can you
help
me and advice on what to do. Thanks alot.