Paul,

My free Excel add-in "List Files" may do what you want.
You can download it here...
http://www.realezsites.com/bus/primitivesoftware

Jim Cone
San Francisco, USA


"grewpp" wrote in message...
Ron,
Thank you for your response.
Example 1 is the closest to what I am looking for.
However, we have over 450 spreadsheets that need to be linked to - this
number does vary from week to week, both up and down. Would there be a
way to create a macro that looks for all excel files within a folder,
and it's subfolders, and create the links?
Thanks again
Paul Grewer