Solved

Can excel2003 use relative links instead of absolute links?

Posted on 2009-05-09
7
543 Views
Last Modified: 2012-05-06
Users have creates excel spreadsheets that use links to other excel spreadsheets. The links are absolute ( they have the full path i.e. c:\documents and settings\username\documents). If I move these excel files to another user or to the server share storage area, then the links do not work as the path has now changed. With Win2008 domain, you can easily move the users My Documents to be stored in a file server rather than the PC. But the links will not work as the path will change. Is it possible to change the excel links from absolute to relative (i.e. from c:\documents and settings\documents\folder1\excelfile1 into .\excelfile1   or c:\documents and settings\documents\folder2\excelfile2  into  ..\folder2\excelfile2 assuming that the original excel file is in another directory-folder1.)
0
Comment
Question by:expuser2008
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 10

Accepted Solution

by:
bob_the_builder earned 500 total points
ID: 24342883
0
 
LVL 10

Expert Comment

by:bob_the_builder
ID: 24354054
Did the above help at all?

Cheers,

Bob
0
 

Author Comment

by:expuser2008
ID: 24355817
Thanks Bob,
   Will try it out as soon as I get some time. Looks like it is in the right direction.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 10

Expert Comment

by:bob_the_builder
ID: 24357777
Let me know how you get on...

Cheers,

Bob...
0
 
LVL 10

Expert Comment

by:bob_the_builder
ID: 24394327
Hi expuser2008,

Did the above solution work or are you still having problems?

Cheers,

Bob
0
 

Author Comment

by:expuser2008
ID: 24448892
I am envloved into too many other projects right now,and for the next month, so I do not have the time to test. But once I test the solution, I will inform you.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Are you irritated by repeating emails issue in Microsoft Outlook 2016 after recent update ?  Lets’ see how to resolve and prevent duplicate emails in the Outlook 2016 using some simple techniques.
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

631 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question