How To Break A Link In Excel

Miscellaneous and Personal Stuff I Must Share
1

How do you do this. I have a worksheet that I like. It was linked to another worksheet. I do not need that second sheet and would like to unlink the two worksheets.

I go to the Edit menu. Then the Links button and then I find the source. There is no option to BREAK a LINK. I tried to change the link to a dead workbook but all it did was add the change link as a new link and kept the old one.

HELP!!

2

I was able to break a link to another workbook simply by changing the contents of the linked cell. Click on the linked cell, delete the contents, and type in whatever you want. Watch the formula bar when you do this - it should change from saying “=[Book2.xls]Sheet1!$A$6” (or whatever) to the value you want.

If you want to keep the information that’s there, don’t copy and paste it into an empty cell with the intention of pasting it back, because it will copy and paste the link too. (this might be a problem if it’s a formula instead of raw data though.)

3

For hyperlinks, just select the cell with the link, hit the hyperlink button and select remove link.

4

Dunno if this will work . . .but you could try

1 Switch to the worksheet that contains the links.
2 On the Tools menu, click Options.
3 On the Calculation tab, clear the Update remote references check box.

Note Clearing the check box overrides the Automatic option (for all links) in the Links dialog box (Edit menu).

OR

Replace a formula with its calculated value

Caution When you replace a formula with its value, Microsoft Excel permanently removes the formula. If you accidentally replace a formula with a value and want to restore the formula, click Undo immediately after you enter or paste the value.

1 Select the cell that contains the formula.

If the formula is an array formula, select the range that contains the array formula.

2 Click Copy .
3 On the Edit menu, click Paste Special.
4 Under Paste, click Values.

Hope it works for you . . .

Tisiphone

5

You can delete the linked file, but that might get messy. Maybe you should listen to the people who actually LIKE the way Windows links files.