can I zap all links in one go?
 

I have a spreadsheet with many links to other spreadsheets in various
unconnected cells. Is there a quick way to paste-special-value these
links rather than doing it cell by cell (there are other formulas in
between that I want to keep)?


--
germullen
------------------------------------------------------------------------
germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626
View this thread: http://www.excelforum.com/showthread...hreadid=563747

can I zap all links in one go?
 

From top menu go to Edit | Links. The pop up window shows a list of all
files you haves linked to. Select each file and click the Break Link button.
This works well if you have only one or a few files linked. However, if
every cell is linked to a different file, it's probably just as much work as
copy | paste special | values for each individual cell.

-Simon

"germullen" wrote:


I have a spreadsheet with many links to other spreadsheets in various
unconnected cells. Is there a quick way to paste-special-value these
links rather than doing it cell by cell (there are other formulas in
between that I want to keep)?


--
germullen
------------------------------------------------------------------------
germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626
View this thread: http://www.excelforum.com/showthread...hreadid=563747

can I zap all links in one go?
 

Thanks Simon, I never thought of looking in the menu !!

I've opened the window, but there's no 'Break links' button. I have
Excel 2000 - is that on a later version?


--
germullen
------------------------------------------------------------------------
germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626
View this thread: http://www.excelforum.com/showthread...hreadid=563747

can I zap all links in one go?
 

When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

There's lots of options in that utility.

germullen wrote:

I have a spreadsheet with many links to other spreadsheets in various
unconnected cells. Is there a quick way to paste-special-value these
links rather than doing it cell by cell (there are other formulas in
between that I want to keep)?

--
germullen
------------------------------------------------------------------------
germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626
View this thread: http://www.excelforum.com/showthread...hreadid=563747

--

Dave Peterson

can I zap all links in one go?
 

yeah, that works, thanks for the -link-.


--
germullen
------------------------------------------------------------------------
germullen's Profile: http://www.excelforum.com/member.php...o&userid=30626
View this thread: http://www.excelforum.com/showthread...hreadid=563747