Home |
Search |
Today's Posts |
#1
|
|||
|
|||
linked cells
What command will find embedded linked cells and to change those cells to
hard values? |
#2
|
|||
|
|||
Try EDIT - LINKS
"titoto" wrote: What command will find embedded linked cells and to change those cells to hard values? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Preserving hyperlinks in linked cells | Excel Discussion (Misc queries) | |||
Linked cells | Excel Discussion (Misc queries) | |||
Update linked cells within a workbook??? | Links and Linking in Excel | |||
Two spreadsheets linked - moving cells | Excel Discussion (Misc queries) | |||
Sorting mixed up linked cells in a workbook? | Excel Worksheet Functions |