='C:\My Documents\excel\[book1.xls]Sheet1'!$A$1 works fine but i had to click on book 1 when window popped up for it to work
