break links to other workbooks

  • Thread starter Thread starter SuzyQ
  • Start date Start date
S

SuzyQ

I have a workbook that has links to other workbooks. I need to email it to
someone who will not have access to the other workbooks, but I want her to
see the values that are in those cells. I know that 2007 has a way to do
this (I think it is called prepare or publish- my version is at home, I'm at
work now with Office 2000). Does Office 2000 Excel have a way to break the
links to other workbooks (and keep the actual value of those cells), so that
someone without access to those workbooks can open the workbook (as a
workbook, not a web page) in order to make edits and return it to me for
review.
 
Under Edit - Links, you can click the button to "break links", thus creating
static values.
 
Under Edit - Links... I get a dialog box that has the following options

*My links are listed on the left
*The right has these buttons
Update Now
Open Source
Change Source
* The bottom has radio buttons for Update
Automatic
Manual (this one is grayed out)

There is no option to break the link that I can see.
 
If you know where the links are (and they're just used in formulas), you could
copy|paste special values to get rid of them.

If you don't know where they are, I'd use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

It has an option to break the link (convert to values).
 
there were too many to go through and copy/paste. But I was able to use the
add-in you linked to. Thanks
 
Back
Top