Results 1 to 6 of 6
  1. #1
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Persistent Link (2003)

    I have a workbook with eight sheets. I use it for a template for monthly financial reports. These have changed over time, and my workbook's sheets may have been created from scratch, copied from other workbooks, etc. Sheet1, named Narrative, has a cell named ReportDate. Each time I do a report, I put the proper date in that cell. There are no other named cells or ranges in the workbook.

    Six of the sheets have a cell containing the formula =ReportDate, and they easily pick up whatever date I enter into the ReportDate cell in Sheet1.

    The seventh sheet, named Operating, has a problem: It has a cell like the others, but it persistently wants to link the ReportDate name to that name in a different workbook (which was made from this template, or used in creating this template, or something else I can't remember). I can break the link in the cell, or delete the contents of the cell, then close and reopen the workbook. When I try to enter =ReportDate into the cell in question, the link reappears.

    It's driving me crazy. Any suggestions?
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  2. #2
    Uranium Lounger
    Join Date
    Dec 2000
    Location
    Salt Lake City, Utah, USA
    Posts
    9,508
    Thanks
    0
    Thanked 6 Times in 6 Posts

    Re: Persistent Link (2003)

    Usually this is solved by changing the range name reference from the external workbook to the correct local cell.
    -John ... I float in liquid gardens
    UTC -7ąDS

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Persistent Link (2003)

    Hi Lou

    This seems a quite good article on the subject of phantom links
    Jerry

  4. #4
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Re: Persistent Link (2003)

    I fixed it, but I don't know how. There were some strange messages about changing the contents of merged cells, and some strange things when I tried the various options under Insert>Names.

    I just went through each sheet and looked at Insert>Names>Paste. If I found a name, I deleted it. There were a couple that seemed strange, but I didn't worry about it.

    When all names had been deleted to the best of my ability, I picked a new name and applied it to the "master" cell on Sheet1. Then I went to each of the other sheets and used Insert>Names>Paste into the proper cell on each.

    Everything seems to work now. Thanks for the tips.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Persistent Link (2003)

    Hi Lou

    Great that it has worked. I think your approach is the best one, clean it out and rename. I find by doing that you save a lot of time instead of trying to find the root cause.
    Jerry

  6. #6
    5 Star Lounger Lou Sander's Avatar
    Join Date
    Jun 2002
    Location
    Pittsburgh, PA
    Posts
    855
    Thanks
    140
    Thanked 10 Times in 9 Posts

    Re: Persistent Link (2003)

    Yes, indeed. I looked fairly closely at the "phantom links" article, and since my problem was no more than a minor annoyance, I figured I'd try the easy way first.
    Lou Sander
    Pittsburgh, Pennsylvania
    USA

Posting Permissions

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