References to other workbooks

G

Guest

Hi!

Does anybody know how can I find out all cell references to other workbooks?
Every time I am opening the workbook, I am asked, if I want to update the
links to other workbooks.
Actualy, I don't want any refernces to other workbooks, so I would like to
delete all these links!

Thanks!
 
G

Guest

I use the standard 'Edit, Find' function in Excel:

Under options Find What {name of the workbook}
Search within: Workbook
Look In: Formulas

You can also take the Edit, Links option and then press the Break Links
button. This permanently substitutes a value for any formulae with links to
external workbooks, so you need to be sure that you no longer need the links
before you use this.
 
G

Guest

alternatively, under the "Find What" if you enter ".xls" (without the
quotes), this will find links to any other workbooks without you having to
enter the workbook name.

Hope this helps
DS
 

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

Unwanted workbooks on startup 2
Linking to Password-required-to-open workbooks 2
Push updates to other workbooks? 10
Close almost all workbooks 2
Who is linking to my file? And what files am I linking to? 1
How to reference a cell from anther workbook without opening it 0
You may not use references to other worksheets or workbooks forConditional Formatting criteria. 2
dynamic reference to data in multiple closed workbooks 2

Top