Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Feb 2001
    Posts
    369
    Thanks
    2
    Thanked 1 Time in 1 Post

    using %documents% in link (2000sr1a)

    Feel v. stupid. Don't know what you call the folder tags used in win2k and others - eg %system%, %user%, so can't find a way to search for the list of them.

    Is there such a thing as %documents%, and if so, will it work in pathnames for linked cells in excel? The address of my files at work and on laptop is the same once below My Documents, but the address of My Documents is different, which currently breaks links to a different workbook.

    Thanks

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

    Re: using %documents% in link (2000sr1a)

    If you're linking Excel spreadsheets, the full pathname isn't required. Excel uses relative pathnames, which means that, provided the folder structure is the same between the source and target, everything should work fine.

    For example, if your target is in C:My DocumentsExcelAnalysis, and the source is in C:My DocumentsExcelData, to Excel this is no different to D:WorkbookAnalysis and D:WorkbookData.
    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
  •