| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I break links to external workbooks en masse?
Hi,
I have a workbook which has links to about a dozen external workbooks. I'd like to sever all external links and just replace those cells' links with values. I know there is VBA code to do this quite easily, but I don't remember what it is.... Thanks. Dave -- Brevity is the soul of wit. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I break links to external workbooks en masse?
Hi Dave,
click on Edit menu, and find a comand link or bond (as my excel is in Braziliam Portuguese, I'm not sure the name), and break all links. once a link is broken excel will maintain the values hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Dave F" escreveu: Hi, I have a workbook which has links to about a dozen external workbooks. I'd like to sever all external links and just replace those cells' links with values. I know there is VBA code to do this quite easily, but I don't remember what it is.... Thanks. Dave -- Brevity is the soul of wit. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I break links to external workbooks en masse?
Thanks. That must be a new feature of xl 2003....
-- Brevity is the soul of wit. "Marcelo" wrote: Hi Dave, click on Edit menu, and find a comand link or bond (as my excel is in Braziliam Portuguese, I'm not sure the name), and break all links. once a link is broken excel will maintain the values hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Dave F" escreveu: Hi, I have a workbook which has links to about a dozen external workbooks. I'd like to sever all external links and just replace those cells' links with values. I know there is VBA code to do this quite easily, but I don't remember what it is.... Thanks. Dave -- Brevity is the soul of wit. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I break links to external workbooks en masse?
thank you Dave, for the feedback, could you please clarify myself about the
menu name in English? is links? -- regards from Brazil Thanks in advance for your feedback. Marcelo "Dave F" escreveu: Thanks. That must be a new feature of xl 2003.... -- Brevity is the soul of wit. "Marcelo" wrote: Hi Dave, click on Edit menu, and find a comand link or bond (as my excel is in Braziliam Portuguese, I'm not sure the name), and break all links. once a link is broken excel will maintain the values hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Dave F" escreveu: Hi, I have a workbook which has links to about a dozen external workbooks. I'd like to sever all external links and just replace those cells' links with values. I know there is VBA code to do this quite easily, but I don't remember what it is.... Thanks. Dave -- Brevity is the soul of wit. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I break links to external workbooks en masse?
Yes, Marcelo
EditLinks Up pops a list of linked books and several options to deal with them Gord On Thu, 5 Oct 2006 12:12:02 -0700, Marcelo wrote: thank you Dave, for the feedback, could you please clarify myself about the menu name in English? is links? |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I break links to external workbooks en masse?
thx Gord,
-- regards from Brazil Thanks in advance for your feedback. Marcelo "Gord Dibben" escreveu: Yes, Marcelo EditLinks Up pops a list of linked books and several options to deal with them Gord On Thu, 5 Oct 2006 12:12:02 -0700, Marcelo wrote: thank you Dave, for the feedback, could you please clarify myself about the menu name in English? is links? |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I break links to external workbooks en masse?
Ciao Marcelo - This feature does not work with Excel 2007. I have a
spreadsheet provided by a customer sent via email. This worksheet has numerous links that point to a file that is not on our environment or will ever be for that matter. When I open this worksheet, cells with broken formulas that have bad links all show "VALUE#!", if I break the links using MS's method, all cells have the word "VALUE#" not the actual value. Any clue how to get around this? Thanks Darrell "Marcelo" wrote: thx Gord, -- regards from Brazil Thanks in advance for your feedback. Marcelo "Gord Dibben" escreveu: Yes, Marcelo EditLinks Up pops a list of linked books and several options to deal with them Gord On Thu, 5 Oct 2006 12:12:02 -0700, Marcelo wrote: thank you Dave, for the feedback, could you please clarify myself about the menu name in English? is links? |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do I break links to external workbooks en masse?
I'm not sure if this registry tweak will work in xl2007--make a note of anything
you changed/added so you can change it back if it fails... Jim Rech posted a registry tweak: http://groups.google.com/groups?thre...GP11.phx .gbl Each recipient will have to make this change. === If it doesn't work, ask the sender to break the links before he/she sends you the file. Darrell wrote: Ciao Marcelo - This feature does not work with Excel 2007. I have a spreadsheet provided by a customer sent via email. This worksheet has numerous links that point to a file that is not on our environment or will ever be for that matter. When I open this worksheet, cells with broken formulas that have bad links all show "VALUE#!", if I break the links using MS's method, all cells have the word "VALUE#" not the actual value. Any clue how to get around this? Thanks Darrell "Marcelo" wrote: thx Gord, -- regards from Brazil Thanks in advance for your feedback. Marcelo "Gord Dibben" escreveu: Yes, Marcelo EditLinks Up pops a list of linked books and several options to deal with them Gord On Thu, 5 Oct 2006 12:12:02 -0700, Marcelo wrote: thank you Dave, for the feedback, could you please clarify myself about the menu name in English? is links? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to break links | Excel Worksheet Functions | |||
| #REF on Links to Named Range in External Workbook | Excel Discussion (Misc queries) | |||
| Hyperlinks - Move file to local drive, all links break | Excel Discussion (Misc queries) | |||
| Links auto update on some workbooks but not others | Excel Worksheet Functions | |||
| how do I activate links without opening external workbooks? | Excel Discussion (Misc queries) | |||
Linear Mode
