Results 1 to 8 of 8
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Posts
    196
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: stripping links (Office 2005)

    I assume you have gone to Edit menu-->Links..., Break Link
    Myabe change the link to manual and/or startup Prompt... and have it not ask to update the link at all.

    hope this helps,
    jackal

  2. #2
    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: stripping links (Office 2005)

    Hi Naomi

    Goto Tool | Options | Edit and untick ask to update links...should work now.
    Jerry

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: stripping links (Office 2005)

    Edit - links
    <break links>

    worked for me...

    Steve

  4. #4
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: stripping links (Office 2005)

    If you want to remove the links altogether, they are evidently "tied" to two hidden "objects" on the Sheet2. Once I removed the two objects, the links were no longer present.

    It is a bit difficult to find the objects. You may wish to simply delete the sheet. There doesn't appear to be anything else on it. If you do want to reveal the objects and delete them while keeping the sheet intact, here's what you need to do...

    1. <LI>Make sure your drawing toolbar is visible. If not, click View | Toolbars and select Drawing.
      <LI>On the far right of the drawing toolbar, there is a small downward arrow. Click the arrow.
      <LI>Then point to Add or Remove Buttons | Drawing, and
      <LI>Click Select Multiple Objects. The new button has been added to your drawing toolbar.
      <LI>Next, click anywhere on the sheet and then click on the newly added button...Select Multiple Objects.
      <LI>A dialogue box will list all of the objects on your worksheet.
      <LI>Select all (both of them).
      <LI>Then use your delete key to be rid of them.
      <LI>Repeat step 5 just to be sure the objects do not reamin on the list.
    - Ricky

  5. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: stripping links (Office 2005)

    Thanks, all. The simple answer worked for me as well: edit, break links. I didn't know it was there. Thanks!

  6. #6
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Brooklyn, New York, USA
    Posts
    200
    Thanks
    2
    Thanked 0 Times in 0 Posts

    stripping links (Office 2005)

    <P ID="edit" class=small>(Edited by Leif on 21-Sep-06 22:08. To remove attachment which had personal information within it.)</P>I created cell links from one excel document to another. I've tried to break all the links and thought I'd found them - I'm really working with a rather small document - but everytime I open it I get a message asking if I want to retain the links. How can I strip this?

  7. #7
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: stripping links (Office 2005)

    F5, Special, Objects also selects all objects but doesn't show you the dialog first (which may be better sometimes). Then Del to remove all.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  8. #8
    Silver Lounger
    Join Date
    Mar 2001
    Location
    Dallas, Texas, USA
    Posts
    1,680
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: stripping links (Office 2005)

    I did not know that. Thanks.
    <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    - Ricky

Posting Permissions

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