Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Links to external files

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    Leicestershire, England
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Can anybody suggest a way to link to cells in other workbooks without opening them.
    The file-name of the link model changes depending on who is using the model so this is held in a seperate cell to the rest of the formula.eg. I've then been using =Indirect(c4,"y11"), where c4 holds the file name and "y11" is the cell reference. This works fine if the other file is in memory, but will error when it is closed. [I used to use the @@ command in Lotus, which worked ok]. Any Ideas ??

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just copy the cells you want to link to and, in a new workbook, Paste Special- Paste Links. When you open up the new workbook, it will automatically update itself without you needing the source book open.

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Leicestershire, England
    Posts
    48
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    That doesn't work because different users will select a different file to link to. I suppose I could use that and write a macro to find and replace filenames within the formula.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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