+ Reply to Thread
Results 1 to 3 of 3

Relative Links Changing Between Network PCs

  1. #1
    Registered User
    Join Date
    12-23-2021
    Location
    San Jose, USA
    MS-Off Ver
    2019
    Posts
    4

    Relative Links Changing Between Network PCs

    My colleague and I share a worksheet using Google drive which we both map locally using an "S" drive. The main worksheet links to individual cells in a large number of other worksheets with a hyperlink that looks something like this ='S:\1 ORDER MASTER FILES\1825 - 1849\1840 \[1840 - Master.xlsx]INVP'!$M$58.

    My colleague recently had to replace his PC and reinstall excel. He mapped the Google drive to S: same as before but now when the file syncs to my G Drive the paths get changed to this ='C:\Users\lowea\AppData\Roaming\Microsoft\Excel\XLSTART\1 ORDER MASTER FILES\1825 - 1849\1840\[1840 - Master.xlsx]INVP'!$M$58.

    I've gone to File - Info and changed the Hyperlink Base to S:\ to try and cement absolute paths but it hasn't helped. He has a laptop setup which hasn't changed and everything is fine if he works on the file on that.

    Can anyone suggest what the problem is?

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Relative Links Changing Between Network PCs

    Have you tried using Data...Edit Links...and changing the source?
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    12-23-2021
    Location
    San Jose, USA
    MS-Off Ver
    2019
    Posts
    4

    Re: Relative Links Changing Between Network PCs

    Will give it a try. The advantage is his laptop works but not his desktop (no, I don't know why he has both!)so I can check settings between them

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Links not working on Network
    By atif_ar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-26-2020, 03:57 PM
  2. Replies: 1
    Last Post: 08-26-2016, 05:06 PM
  3. Network Formula Links
    By Rustyroof in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-24-2015, 11:06 AM
  4. Replies: 0
    Last Post: 10-14-2009, 03:23 PM
  5. [SOLVED] Paste Links over a Network
    By don in forum Excel General
    Replies: 2
    Last Post: 12-16-2005, 01:10 PM
  6. [SOLVED] Relative Links becoming Absolute Links?
    By GB in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-03-2005, 03:05 PM
  7. workbook links to .xla file on the network
    By compound in forum Excel General
    Replies: 0
    Last Post: 07-06-2005, 02:27 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1