Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    224
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Links to Other Spreadsheets (Excel 2000)

    Hi,

    I have taken over a spreadsheet which has inthe past links to other spreadsheets which are no longer required, it keeps coming up with the request to update links and I cannot stop this, any ideas how this can be stopped as it takes an age to open.

    Regards

    Mike

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

    Re: Links to Other Spreadsheets (Excel 2000)

    You can download and install Bill Manville's free FindLink add-in from Office Automation Ltd. - The Excel MVP Page. It'll let you break all links.

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Links to Other Spreadsheets (Excel 2000)

    See if Bill Manville's free utility findlink will help. FINDLINK
    Legare Coleman

  4. #4
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Links to Other Spreadsheets (Excel 2000)

    Hi Mike,

    Another method is to choose Edit | Links and view the references to the external links in this dialog. Seeing that you have Excel 2000, you could use Edit | Find to locate these references and Copy | PasteSpecial...Values to break the links. If you have access to Excel 2002 (XP) you can use the Break Links button to severe the links to these external files.
    Regards,
    Rudi

  5. #5
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    224
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Links to Other Spreadsheets (Excel 2000)

    Thanks Hans,

    I have tried this utility, it took hours and did not do anything, the links still remained, even thought I told it to delete all.

    I also tried the Break Links options and this crashed Excel, several times.

    Any other ideas.

    Regards

    Mike

  6. #6
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    224
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Links to Other Spreadsheets (Excel 2000)

    Thanks Rudi,

    I tried this and it crashed Excel several times.

    Regards

    Mike

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

    Re: Links to Other Spreadsheets (Excel 2000)

    From your description, it seems there is something wrong with the workbook. Ordinarily, the FindLink add-in should work quickly, and the Break Links option too. You can try copying the contents of worksheets and use Edit | Paste Special..., Values option to paste them into a new workbook, but that way you'll lose ALL formulas, not only the external links.

  8. #8
    3 Star Lounger
    Join Date
    Nov 2001
    Posts
    224
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Links to Other Spreadsheets (Excel 2000)

    Thanks Hans,

    I guess that would be the case, I have some other issues with spreadsheet, I have placed another post on the same sheet.

    Thanks

    Mike

Posting Permissions

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