linked cells
 

What command will find embedded linked cells and to change those cells to
hard values?

Try EDIT - LINKS

"titoto" wrote:

What command will find embedded linked cells and to change those cells to
hard values?

IT DOESN'T TELL WHICH CELL(S) CONTAINS LINKS

"Barb R." wrote:

Try EDIT - LINKS

"titoto" wrote:

What command will find embedded linked cells and to change those cells to
hard values?

You could search for [ or ] or .xls or use a nice utility already written.

Bill Manville's FindLink addin may help you find the hard to find links:
http://www.oaltd.co.uk/MVP/Default.htm

titoto wrote:

What command will find embedded linked cells and to change those cells to
hard values?

--

Dave Peterson

It's not easy to find.

May need to browse through the cells and detect the formula. An Excel tool
called auditing may help to relieve some pain. Go to Views, Toolbars and
check the Formula Auditing. There are two buttons, one called 'trace
precedents' and one 'trace descendants' that would show the link trail.

If you want to 'freeze' the value as populated in the cells with formulas,
simply select the whole sheet (by clicking the left top corner next to the
first column), copy, and go to edit, paste special and select value only

Hope this helps...


"titoto" wrote:

What command will find embedded linked cells and to change those cells to
hard values?