Excel should allow clicking on a linked cell to jump to source

[Hayk]

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/com...dg=microsoft.public.excel.worksheet.functions

 

[Peo Sjoblom]

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

--


Regards,


Peo Sjoblom

 

[Gord Dibben]

You already have this functionality.

In Tools>Options>Edit 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

 

[Hayk]

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 ?

You already have this functionality.

In Tools>Options>Edit 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

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/com...dg=microsoft.public.excel.worksheet.functions

 

[Roger Govier]

Hi

For XL2007,
press the Round Office button>Excel Options>Advanced>Editing
Options>uncheck Allow editing directly in Cell

--

Regards
Roger Govier

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 ?

You already have this functionality.

In Tools>Options>Edit 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

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/com...dg=microsoft.public.excel.worksheet.functions

 

[Gord Dibben]

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

On Office 2007 see Roger's reply.


Gord

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 ?

You already have this functionality.

In Tools>Options>Edit 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

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/com...dg=microsoft.public.excel.worksheet.functions

 

[Shah Shailesh]

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

Hi

For XL2007,
press the Round Office button>Excel Options>Advanced>Editing
Options>uncheck Allow editing directly in Cell

--

Regards
Roger Govier

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 ?

You already have this functionality.

In Tools>Options>Edit 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

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/com...dg=microsoft.public.excel.worksheet.functions

 

[Roger Govier]

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

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

Hi

For XL2007,
press the Round Office button>Excel Options>Advanced>Editing
Options>uncheck Allow editing directly in Cell

--

Regards
Roger Govier

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 ?

:

You already have this functionality.

In Tools>Options>Edit 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

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/com...dg=microsoft.public.excel.worksheet.functions

 

[Gord Dibben]

I would like to second that.


Gord Dibben MS Excel MVP

 

[ilia]

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.