Double-click referencing to other worksheets

[apubapu82]

What do I need to do to enable double-click referencing to other worksheets? For example, I am working on Workbook A which links to data in Workbook B. I want to be able to double click on a cell in Workbook A and pull up the linking data in Workbook B.

Any assistance regarding this matter would be greatly appreciated! Thanks!

[Gord Dibben]

Tools>Options>Edit.

Uncheck "edit directly in cell".


Gord Dibben MS Excel MVP

On Wed, 5 Apr 2006 13:54:55 -0500, apubapu82
<[email protected]> wrote:

>
>What do I need to do to enable double-click referencing to other
>worksheets? For example, I am working on Workbook A which links to
>data in Workbook B. I want to be able to double click on a cell in
>Workbook A and pull up the linking data in Workbook B.
>
>Any assistance regarding this matter would be greatly appreciated!
>Thanks!

[apubapu82]

Thanks so much for the prompt response!