Hello,

Is it possible for the INDIRECT function to be tweaked so it updates even when the external workbook is closed?

Also does anyone have any idea why
=INDIRECT("C:\Documents and Settings\*****\Desktop\Excel[book2.xls]Sheet1!C"&C2)
Produces a #REF! error code?


Any help would be greatly appreciated :D