When you paste a link from one excel file to the next. Excel should have an
option to jump to the source of the data by clicking on any cell that
contains a formula link.

For example: If i have the following formula in a cell:

='[Correspondent Rates.xls]Correspondent'!$E128

Excel should allow me to jump to the file in Correspondent Rates.xls Sheet
Correspondent row/column E128 by clicking on it, instead of manually locating
the file and jumping to that row/column.



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions