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