Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Paul134
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 Rich Rodberg Links and Linking in Excel 1 October 21st 05 07:53 AM
Some Excel links don't work Ben Enfield Excel Discussion (Misc queries) 3 August 2nd 05 12:29 AM
Why does my Excel workbook take so long to update links? Bannor Excel Discussion (Misc queries) 0 July 26th 05 11:47 AM
Creating Relative Links in Excel... colleenh Excel Discussion (Misc queries) 1 June 28th 05 10:47 PM
Updating Links to Other Excel Files JAD Excel Worksheet Functions 1 May 17th 05 01:42 AM


All times are GMT +1. The time now is 08:15 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"