Referencing Path
 

Currently I'm working in an excel sheet with a summary page that is linked to
a number of tabs that support it. In the 2003 version of excel I would be
able to double click the cell and it would take me to the referenced cell on
the appropriate tab. However in the new version Vista it does not do this,
but instead just expands the formula. Is there a way to change the settings
in order so it can perform the same function as the 2003 version.

Thanks

Referencing Path
 

In 2003 if you uncheck in ToolsOptionsEdit "edit directly in cell" you will
jump to the link upon double-click.

Probably same setting in 2007 but I don't know where that would be.

BTW................Vista is an operating system, not an Office application.

I assume you mean Office 2007


Gord Dibben MS Excel MVP

On Thu, 3 Jul 2008 12:30:01 -0700, Wicad
wrote:

Currently I'm working in an excel sheet with a summary page that is linked to
a number of tabs that support it. In the 2003 version of excel I would be
able to double click the cell and it would take me to the referenced cell on
the appropriate tab. However in the new version Vista it does not do this,
but instead just expands the formula. Is there a way to change the settings
in order so it can perform the same function as the 2003 version.

Thanks

Referencing Path
 

Like you Gord, not familiar with XL07, but this probably still works in
XL07, same as earlier versions:

To *retain* the "Edit In Cell" functionality, don't disable it, but simply
click in cell, then
<Ctrl < [
to jump to the precedent cell(s).

<Ctrl < ]
to jump to the dependent cell(s).
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
In 2003 if you uncheck in ToolsOptionsEdit "edit directly in cell" you
will
jump to the link upon double-click.

Probably same setting in 2007 but I don't know where that would be.

BTW................Vista is an operating system, not an Office
application.

I assume you mean Office 2007


Gord Dibben MS Excel MVP

On Thu, 3 Jul 2008 12:30:01 -0700, Wicad
wrote:

Currently I'm working in an excel sheet with a summary page that is linked
to
a number of tabs that support it. In the 2003 version of excel I would be
able to double click the cell and it would take me to the referenced cell
on
the appropriate tab. However in the new version Vista it does not do this,
but instead just expands the formula. Is there a way to change the
settings
in order so it can perform the same function as the 2003 version.

Thanks