Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding cells that contain references to other workbooks
Howdy -
How do I find out what cells in a specific workbook contain the formulas that drive the link to another workbook? Simply put, I have a lot of workbooks I inherited and have old links I know I do not need, but I can't figure out how to eliminate them |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding cells that contain references to other workbooks
Edit Links Break Links.
Make sure that's what you really want to do!! Total PITA if you break links and find out later that you really need them!! Good luck, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "John Cunha" wrote: Howdy - How do I find out what cells in a specific workbook contain the formulas that drive the link to another workbook? Simply put, I have a lot of workbooks I inherited and have old links I know I do not need, but I can't figure out how to eliminate them |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding cells that contain references to other workbooks
Absolutely. I know intimately what I want from these workbooks from A to Z
and Alpha to Omega, and have no need for whatever links were created by their ancient authors. In fact, I don't even have the reference workbooks. SO I'd really love to skip the initial link update window - now there's the true PITA! "ryguy7272" wrote: Edit Links Break Links. Make sure that's what you really want to do!! Total PITA if you break links and find out later that you really need them!! Good luck, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "John Cunha" wrote: Howdy - How do I find out what cells in a specific workbook contain the formulas that drive the link to another workbook? Simply put, I have a lot of workbooks I inherited and have old links I know I do not need, but I can't figure out how to eliminate them |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding file references within cells | Excel Discussion (Misc queries) | |||
Help with converting a block of cells with Absolute and mixed references to relative references | Excel Worksheet Functions | |||
Finding Cells in a Workbook Linked to Other Workbooks | Excel Discussion (Misc queries) | |||
Finding linked cells to other workbooks | Excel Discussion (Misc queries) | |||
Finding Cell References | Excel Discussion (Misc queries) |