Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    May 2003
    Location
    South Australia, Singapore
    Posts
    22
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Deleting Links (Excel 97) (Excel 97)

    My colleague has send me a template that she has designed. However, she has some link this file with other files. Whenever I open this file, it will prompt me whether I want to update the link.
    How can I delete the links so that no message will be prompted whenever I open this file??

  2. #2
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Deleting Links (Excel 97) (Excel 97)

    Yes, I had this irritation.
    I overcame it by going to the 'Change Links' box and linked the file to itself.
    Everything them became greyed out and no more grief (for this reason, anyway.)

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Deleting Links (Excel 97) (Excel 97)

    (Edited by HansV to update link to Excel MVP site)

    You can download the free Findlink utility from http://www.bmsltd.ie/mvp/. It will allow you to locate all links in a workbook, and gives you the option to replace them by values.

Posting Permissions

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