break links to other workbooks
 

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.

break links to other workbooks
 

Under Edit - Links, you can click the button to "break links", thus creating
static values.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


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

break links to other workbooks
 

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.

"Luke M" wrote:

Under Edit - Links, you can click the button to "break links", thus creating
static values.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


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

break links to other workbooks
 

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

break links to other workbooks
 

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