there were too many to go through and copy/paste. But I was able to use the
add-in you linked to. Thanks

"Dave Peterson" wrote:

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).

SuzyQ wrote:

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.

--

Dave Peterson