Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2002
    Location
    Wheaton, IL
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have an Excel2010 spreadsheet (xlsb) which is linked to a csv file. I set the relative base for hyperlinks and when I created the many links, they were fine and included only the target file and cell.. The csv file and the workbook are in the same directory. When the file was reopened and the links allowed to update, excel had converted all of the hyperlinks from relative to fully qualified. We tried this from both my machine and an associates machine.

    - What causes this behavior and how do I prevent it?
    - Where can I find an explanation of exactly how this process works?


    Thanks,

    Jim

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,170
    Thanks
    47
    Thanked 980 Times in 910 Posts
    This has been the case with all versions of Excel I can remember. Don't know if there's a way to prevent it.

    cheers, Paul

  3. #3
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Hi Jim,

    Although you see the fully qualified path, Excel stores it as a relative path, not as an absolute path. If you close & move the files to another folder, the path will update to reflect that.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

Posting Permissions

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