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

It does already, if you clear "edit directly in the cell" under
toolsoptionsedit then double click the cell with the link it will go
there.

--


Regards,


Peo Sjoblom




"Hayk" wrote in message
...
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

You already have this functionality.

In ToolsOptionsEdit uncheck "Edit Directly in Cell"

Double-click on the cell with the link and the other workbook will open to that
sheet and cell address.


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 15:11:01 -0800, Hayk wrote:

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

Yes, but will it go directly to the cell rather than just open the file?

And how would I do this on a office 2007 ?

"Gord Dibben" wrote:

You already have this functionality.

In ToolsOptionsEdit uncheck "Edit Directly in Cell"

Double-click on the cell with the link and the other workbook will open to that
sheet and cell address.


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 15:11:01 -0800, Hayk wrote:

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

Hi

For XL2007,
press the Round Office buttonExcel OptionsAdvancedEditing
Optionsuncheck Allow editing directly in Cell

--

Regards
Roger Govier

"Hayk" wrote in message
...
Yes, but will it go directly to the cell rather than just open the file?

And how would I do this on a office 2007 ?

"Gord Dibben" wrote:

You already have this functionality.

In ToolsOptionsEdit uncheck "Edit Directly in Cell"

Double-click on the cell with the link and the other workbook will open
to that
sheet and cell address.


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 15:11:01 -0800, Hayk
wrote:

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

Hi Roger and Hayk,


In case you want to use keyboard shortcut keys, just press ctrl - [ .
i.e. Hold control key with "[" bracket (next to "P" key), to jump to the
linked cell.
Works also in the previous versions.

Allow editing directly in Cell is useful for quick editing of cells. So I
think there is no need to uncheck Allow editing directly in Cell unless you
want to jump with a double-click on the cell.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
If You Can't Excel with Talent, Triumph with Effort.

Free Addins Office Menu-2003 for Office-2007
http://in.geocities.com/shahshaileshs/menuaddins






"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi

For XL2007,
press the Round Office buttonExcel OptionsAdvancedEditing
Optionsuncheck Allow editing directly in Cell

--

Regards
Roger Govier

"Hayk" wrote in message
...
Yes, but will it go directly to the cell rather than just open the file?

And how would I do this on a office 2007 ?

"Gord Dibben" wrote:

You already have this functionality.

In ToolsOptionsEdit uncheck "Edit Directly in Cell"

Double-click on the cell with the link and the other workbook will open
to that
sheet and cell address.


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 15:11:01 -0800, Hayk
wrote:

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

Hi Shah

I was totally unaware of that shortcut.
Thanks for bringing it to my attention.
Much better than switching off editing in cell.

--

Regards
Roger Govier

"Shah Shailesh" wrote in message
...
Hi Roger and Hayk,


In case you want to use keyboard shortcut keys, just press ctrl - [ .
i.e. Hold control key with "[" bracket (next to "P" key), to jump to the
linked cell.
Works also in the previous versions.

Allow editing directly in Cell is useful for quick editing of cells. So I
think there is no need to uncheck Allow editing directly in Cell unless
you want to jump with a double-click on the cell.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
If You Can't Excel with Talent, Triumph with Effort.

Free Addins Office Menu-2003 for Office-2007
http://in.geocities.com/shahshaileshs/menuaddins






"Roger Govier" <roger@technology4unospamdotcodotuk wrote in message
...
Hi

For XL2007,
press the Round Office buttonExcel OptionsAdvancedEditing
Optionsuncheck Allow editing directly in Cell

--

Regards
Roger Govier

"Hayk" wrote in message
...
Yes, but will it go directly to the cell rather than just open the file?

And how would I do this on a office 2007 ?

"Gord Dibben" wrote:

You already have this functionality.

In ToolsOptionsEdit uncheck "Edit Directly in Cell"

Double-click on the cell with the link and the other workbook will open
to that
sheet and cell address.


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 15:11:01 -0800, Hayk
wrote:

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

I did mention "will open to that sheet and cell address".

On Office 2007 see Roger's reply.


Gord

On Fri, 7 Dec 2007 16:16:00 -0800, Hayk wrote:

Yes, but will it go directly to the cell rather than just open the file?

And how would I do this on a office 2007 ?

"Gord Dibben" wrote:

You already have this functionality.

In ToolsOptionsEdit uncheck "Edit Directly in Cell"

Double-click on the cell with the link and the other workbook will open to that
sheet and cell address.


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 15:11:01 -0800, Hayk wrote:

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

Press Ctrl+[ to go to the next-lower level precedent cells. Press Ctrl
+] to go to the next-higher level of dependent cells. Going forward
(dependents) will highlight all affected cells, similarly to how Trace
Dependents/Precedents arrow would.


Hayk wrote:
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