Identify links
 

Dear All,

I have a worksheet with lots of formulas. Some of these
formulas are linked to other workbooks in the same
directory. Is there a way I can identify all the links
without having to check all the formulas? Thanks for your
help.

Helal

Edit / Links will show you which other workbooks this workbook is
linked to, but will not show you where the links are used.

If you want to know where the links are used, download FINDLINK from
http://www.oaltd.co.uk/mvp

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Just want to add my thanks to Bill Manville for the solution to my problem.

I was having a problem with links to other workbooks which, as it turned out, resulted from my
having copied formulas from one workbook to another without realizing that I was creating a
link. When asked if I wanted to update the links, I asked myself "What links?" and "How do I
find them?" -- among other things. I came to this NG hoping to find the solution, and your
FindLinks.xla did exactly that.

Now I'd like to ask a new questions: Why does Excel 2002 ask me if I want to "save the changes"
when I've made no changes? All I've done is open the file, look at it, and try to close it. No
changes, no nothing. Just looking. And there are no macros in those files either. Or is this
just the nature of Excel?

Thank you.

Terry



"Bill Manville" wrote in message ...

Edit / Links will show you which other workbooks this workbook is
linked to, but will not show you where the links are used.

If you want to know where the links are used, download FINDLINK from
http://www.oaltd.co.uk/mvp

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Pleased that FINDLINK helped you.

If your worksheet has any formulas that call "volatile" functions then
you will be prompted to save the workbook. Such functions return
different values at different times.

Examples:
TODAY(), NOW(), RAND()

You may also be prompted if the workbook was last saved by a different
version of Excel, which causes Excel 2002 to do a full rebuild of the
calculation chain and recalculate

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Okay, that explains it. I use RAND() in one of the worksheets of that workbook.

Again, thanks for the help, plus, I learned something -- and that doesn't happen as often as it
should. :-)

Terry