Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 557
  • Last Modified:

Can excel2003 use relative links instead of absolute links?

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
expuser2008
Asked:
expuser2008
  • 4
  • 2
1 Solution
 
bob_the_builderCommented:
0
 
bob_the_builderCommented:
Did the above help at all?

Cheers,

Bob
0
 
expuser2008Author Commented:
Thanks Bob,
   Will try it out as soon as I get some time. Looks like it is in the right direction.
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
bob_the_builderCommented:
Let me know how you get on...

Cheers,

Bob...
0
 
bob_the_builderCommented:
Hi expuser2008,

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

Cheers,

Bob
0
 
expuser2008Author Commented:
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

Technology Partners: 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!

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now