Finding cells that contain references to other workbooks

J

John Cunha

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
 
R

ryguy7272

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---
 
J

John Cunha

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding Invalid References 1
XL2000 Links Between Workbooks 2
detect cells with links 5
Add cells across multiple workbooks that increase... 8
Hyperlink to cells in other workbooks keep changing 3
Finding links to other files 3
Link To File That No Longer Exists 1
Links to other workbooks 1

Top