Forum Discussion

wouter.scheerlinck's avatar
wouter.scheerlinck
Copper Contributor
Aug 02, 2017
Solved

Remove link

Hi all,

 

In a Excel book, I have a not removable link to a not exsisting xlsm file. I tried to remove it with "Break Link", but it doesn't work.

Some suggestions?

Thnx!

12 Replies

  • Anonymous's avatar
    Anonymous

    Hi Wouter,

    • Place the cursor on the cell that has the link.
    • Press F9 key
    • Press Enter key

    Hope that helps..

    • Moyna Good's avatar
      Moyna Good
      Copper Contributor

      I wouter, I can't find the cell with the link, any idea how I find it please?

    • wouter.scheerlinck's avatar
      wouter.scheerlinck
      Copper Contributor

      Hi Balakrisna,

       

      That's part of the problem, I think. There are no cells links to this external file.

      When I start a search with ".xl", it gives no result.

      • Anonymous's avatar
        Anonymous

        Hi Wouter,

        Can you try recalculating the entire workbook using the key combination "CTRL + SHIFT + F9" and then check to see if the link still shows up in the "Edit Links" dialogue.

         

        Thanks,

        Balakrishna

Resources