Results 1 to 5 of 5
  1. #1
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Breaking a link (2000)

    Did you intend to post this in the Access forum, or did you mean to post it in the Excel forum? If the latter, I will move it there - otherwise, I don't understand the relevance to Access.
    Wendell

  2. #2
    New Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Breaking a link (2000)

    Yes, thank you for spotting that. It was meant for Excel. I'd appreciate your moving it.

    Many thanks

    Godfrey

  3. #3
    New Lounger
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Breaking a link (2000)

    <P ID="edit" class=small>(Edited by HansV on 18-Aug-03 09:17. This post was moved here from the Access forum, where it was originally posted.)</P>In Excel 2002, when I want to break a link to a source sheet, the Edit>Links dialogue box offers me that option. i need to tell a client how to do that in Excel 2000 where the Edit>Links box has fewer options?

    Would someone be so kind as to tell me how to do this in Excel 2000

    Thanks in anticipation

    Godfrey

  4. #4
    2 Star Lounger
    Join Date
    Jul 2002
    Location
    Paragould, Arkansas, USA
    Posts
    194
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Breaking a link (2000)

    Godfrey,
    Try changing the link so the link points back to the sheet you're working on. i.e., if you have a link from Book1 to a formula in Book2, then on Book2, change the link so it points to Book2. The downside is any cells with the link will only point to themselves and whatever value is in the corresponding cell(s) in Book2. (So, if you know where these formulae are, copy|paste value or something.)

    This formula: <font face="Georgia">=[Book2.xls]Sheet1!$D$6</font face=georgia>
    becomes <font face="Georgia">=Sheet1!$B$6</font face=georgia>

    Errol

  5. #5
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Breaking a link (2000)

    This is also a problem with Excel 97. The standard solution is to use Bill Manning's Add-In at http://www.bmsltd.ie/mvp/. You may need to test this to see whether this does precisely what you want it to do.
    Gre

Posting Permissions

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