I have 2 excel files, one the Working/Info Details and the other Display.
All the infomation will extract from the Working/Info file by using the
following sample format.

= 'C:\project\[working_info_details.xls]info'!A1 OR
= 'C:\project\[working_info_details.xls]Detail'!H1

My problem is that when I change the Working/Info Details file name, the
Display file is unable to extract the infomation anymore.

How can I change the working file name and the display file will
automatically updated and point to the file with a new name.

Also is there a much better way where I can have the same result, a working
file and a display file.

Pls advice.

Thanks
vcff
where I can work with