Solved

Can excel2003 use relative links instead of absolute links?

Posted on 2009-05-09
7
523 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
  • 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
macro for active word document 4 39
increment numbers by 10 11 29
Excel - find text within text? 1 21
Filling Blank Cells 14 15
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.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

919 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now