Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HELP!!! Missing Links!!! | New Users to Excel | |||
Manual Refresh of Links | Excel Discussion (Misc queries) | |||
Update Individual Links | Excel Discussion (Misc queries) | |||
Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) | |||
Why do my links break when I burn multiple Excel files to a CD? | Excel Worksheet Functions |