Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Break a link between workbooks when there is no "break" option | Excel Discussion (Misc queries) | |||
Break Links But Keep Formulas | Excel Discussion (Misc queries) | |||
Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
how do I break links to external workbooks en masse? | Excel Discussion (Misc queries) | |||
Break Links | Excel Discussion (Misc queries) |