T
titoto
What command will find embedded linked cells and to change those cells to
hard values?
hard values?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
Barb R.
Try EDIT -> LINKS
T
titoto
D
Dave Peterson
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
Bill Manville's FindLink addin may help you find the hard to find links:
http://www.oaltd.co.uk/MVP/Default.htm
A
Anki
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...
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...