can excel links be somehow relative to folder structure?
 

Lets say there is a network folder named for each month, inside there is
a bundle of heavily linked reports that cannot be integrated into just
one workbook. Each new month the folder is copied and renamed to the
current month to update the data. Links keeps pointing to previous
folder structure and changing them it's time wasting and confusing
because of the little room on the excel links dialog...

I have not yet found a way to make the process practical as it is in
webpages. Why can't links just point to the files regardless of folder
or even use ../folder_x/ to force them navigate into the folder
structure as it is in webpages relative links?

Well, obviously excel is one program and webpages are other thing, but
perhaps someone else having the same inconvenience has found a better
way to do it or can give some advice...

Thanks. Paul.


--
Paul134
------------------------------------------------------------------------
Paul134's Profile: http://www.excelforum.com/member.php...o&userid=31735
View this thread: http://www.excelforum.com/showthread...hreadid=518220