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

Thread: Excel Linked Cells

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    We have a number of excel spreadsheets which contain links to other spreadsheets. In the future, we are planning on changing our directory structure which will cause problems for the cells that contain links to other spreadsheets. Is there a simple way to identify the cells which have links in them, the link itself, and a someway to change the links without having to change every linked cell in every spreadsheet?

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    if it were me, with 10 files, I'd open them all up then save them to the new directory.... all the links would change automatically.

    My guess is you have a lot more than 10 though, right ?

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Why dont you put the file path being linked to in A2 say, like

    C:MyFile2001myfile.xls

    then, use indirect function to link.

    For instance

    =INDIRECT(A2,T65)

    I think would pick out T65 from C:MyFile2001myfile.xls
    which is in A2.

    So next year, just put the new path in A2, and your whole spreadsheet will be updated.

    RET79







  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I think what I am describing is parameterising file names.

    It's very effective, and rigid. Changing one cell with the file path updates the whole sheet or book.

    wicked

    RET79

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
  •