| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a Linked Cell
Hi! Everytime I open up a certain workbook, it asks me if
I want to update the links when it shouldn't have any. I was wondering if there is a way to find which cell in which tab has the rogue link? VBE or some other way is fine. Thanks!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding a Linked Cell
Since links are always contain brackets, try doing a find for the "[". When
you do the find, select the option that searches the entire workbook. -- Michael J. Malinsky "michael" wrote in message ... Hi! Everytime I open up a certain workbook, it asks me if I want to update the links when it shouldn't have any. I was wondering if there is a way to find which cell in which tab has the rogue link? VBE or some other way is fine. Thanks!! |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Finding a Linked Cell
Hi michael,
why don't you try Bill Manvill's "Findlink" http://www.bmsltd.co.uk/MVP/Default.htm Wolf -----Original Message----- Hi! Everytime I open up a certain workbook, it asks me if I want to update the links when it shouldn't have any. I was wondering if there is a way to find which cell in which tab has the rogue link? VBE or some other way is fine. Thanks!! . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I have a linked cell auto-size to fit the linked data? | Excel Discussion (Misc queries) | |||
| Finding Cells in a Workbook Linked to Other Workbooks | Excel Discussion (Misc queries) | |||
| Finding linked cells to other workbooks | Excel Discussion (Misc queries) | |||
| Finding the cell that is linked to a file | Excel Discussion (Misc queries) | |||
| Finding a linked cell | Links and Linking in Excel | |||
Linear Mode
