Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
detect cells with links
How can I detect on an excel workbook which cell have links(formula =) to
other workbooks without have to put my cursor on top of each linked cell. I have had a hard time finding this cells. I can see the links by choosing Edit then links, and excel will display list of links, but it does not specify which cells contain those links |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
detect cells with links
Have you looked at 'Tools'...'formula auditing'....then trace precedants and
dependants? "Hugh Hoffman" wrote: How can I detect on an excel workbook which cell have links(formula =) to other workbooks without have to put my cursor on top of each linked cell. I have had a hard time finding this cells. I can see the links by choosing Edit then links, and excel will display list of links, but it does not specify which cells contain those links |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
detect cells with links
Yes, and it will show me the linked workbook only if I place my cursor on the
appropriate cell, on the cell that has the link with that workbook, if I do not place myself on the corresponding cell, I have not found I way to detect which cells contain such type of linkage "tim m" wrote: Have you looked at 'Tools'...'formula auditing'....then trace precedants and dependants? "Hugh Hoffman" wrote: How can I detect on an excel workbook which cell have links(formula =) to other workbooks without have to put my cursor on top of each linked cell. I have had a hard time finding this cells. I can see the links by choosing Edit then links, and excel will display list of links, but it does not specify which cells contain those links |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
detect cells with links
Use Bill Manville's free FINDLINK addin
http://www.oaltd.co.uk/MVP/Default.htm -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Hugh Hoffman" <Hugh wrote in message ... How can I detect on an excel workbook which cell have links(formula =) to other workbooks without have to put my cursor on top of each linked cell. I have had a hard time finding this cells. I can see the links by choosing Edit then links, and excel will display list of links, but it does not specify which cells contain those links |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
detect cells with links
Thank you so much MASTER
"Ken Wright" wrote: Use Bill Manville's free FINDLINK addin http://www.oaltd.co.uk/MVP/Default.htm -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------Â*------------------------------Â*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------Â*------------------------------Â*---------------- "Hugh Hoffman" <Hugh wrote in message ... How can I detect on an excel workbook which cell have links(formula =) to other workbooks without have to put my cursor on top of each linked cell. I have had a hard time finding this cells. I can see the links by choosing Edit then links, and excel will display list of links, but it does not specify which cells contain those links |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
detect cells with links
LOL - You're very welcome :-)
"Hugh Hoffman" wrote in message ... Thank you so much MASTER "Ken Wright" wrote: Use Bill Manville's free FINDLINK addin http://www.oaltd.co.uk/MVP/Default.htm -- Regards Ken....................... Microsoft MVP - Excel Sys Spec - Win XP Pro / XL 97/00/02/03 ------------------------------*------------------------------*---------------- It's easier to beg forgiveness than ask permission :-) ------------------------------*------------------------------*---------------- "Hugh Hoffman" <Hugh wrote in message ... How can I detect on an excel workbook which cell have links(formula =) to other workbooks without have to put my cursor on top of each linked cell. I have had a hard time finding this cells. I can see the links by choosing Edit then links, and excel will display list of links, but it does not specify which cells contain those links |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to copy a row with transposing to a column retaining links to input cells? | Excel Worksheet Functions | |||
Maintain proper links when Excel cells are moved | Excel Discussion (Misc queries) | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Help adding text values | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |