Removing Links From Cells

  • Thread starter Thread starter SamuelT
  • Start date Start date
S

SamuelT

Hi all,

Can anyone tell me how to remove links from cells? I have a workboo
that has a number of cells copied from another workbook. I want to kee
the formula that the cells have, but remove the link from the paren
spreadsheet.

Any ideas?

TIA,

Samuel
 
When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

And depending on what version of excel you're running, you may be able to use:

Edit|Links
select the link you don't want
and click the Break link button
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing links 0
Excel Linking (I think) 17
Invalid References 1
linked cells will not update 1
How to create absolute link to cell in another workbook (Excel 2003) 1
Displaying zeros in cells 2
Problem linking to a cell with a date. 1
Excel How to add numbers in same cell? 2

Back
Top