#1   Report Post  
Helal
 
Posts: n/a
Default 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   Report Post  
Bill Manville
 
Posts: n/a
Default


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   Report Post  
Terry
 
Posts: n/a
Default

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   Report Post  
Bill Manville
 
Posts: n/a
Default

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   Report Post  
Terry
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP!!! Missing Links!!! [email protected] New Users to Excel 2 February 16th 05 04:20 PM
Manual Refresh of Links Carl Bowman Excel Discussion (Misc queries) 1 February 15th 05 04:11 AM
Update Individual Links mikxtr Excel Discussion (Misc queries) 3 January 21st 05 05:24 AM
Links in formulas change when another user runs a workbook L Mehl Excel Discussion (Misc queries) 2 November 27th 04 10:27 PM
Why do my links break when I burn multiple Excel files to a CD? akrr-rasmussen Excel Worksheet Functions 1 November 17th 04 03:39 AM


All times are GMT +1. The time now is 01:07 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"