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