Ask Your Question
0

Spreadsheet link won't go away

asked 2015-11-07 23:30:00 +0200

Roger Davis gravatar image

I have an old spreadsheet with a link. I no longer need the link.

I went to Edit>Links>Break Link, answered Yes, and the link disappeared from the list, which is then empty.

I saved the spreadsheet and reopened it. The link has reappeared. I repeated this three times.

How do I lose the link?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

answered 2015-11-19 16:07:28 +0200

pierre-yves samyn gravatar image

Hi

May be you can try EditFind & Replace,

  • Search For: file:/
  • Other options: Search inFormulas

This allows you to find cells containing a formula that links to a file. You could then use e.g. ToolsCell ContentsFormula to Value to delete the link and keep the value.

You can also verify that names (created by InsertNames) do not create links pointing to files.

Regards

edit flag offensive delete link more

Comments

Good way, because maybe the link is created with an INDIRECT() or a DDE() function so break link can't break it, because the link is recreated by the functions.

m.a.riosv gravatar imagem.a.riosv ( 2015-11-19 22:38:53 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-11-07 23:30:00 +0200

Seen: 96 times

Last updated: Nov 19 '15