Been a long time since I used 97 but I think you could select Place in this
document even back then.

Is that not available?


Gord Dibben MS Excel MVP

On Wed, 1 Apr 2009 12:40:05 -0700, rmpete
wrote:

Great information!
but how would you do it in Excel 97?
Thanks

"Gord Dibben" wrote:

InsertHyperlink

From the Link to: bar select Place in this document.


Gord Dibben MS Excel MVP

On Wed, 5 Dec 2007 13:17:05 -0800, Todd wrote:

Thank you Conan,
that works quite well.

however. i have used hyperlinks in the past, to jump to other workbooks.
but, is there a way to use a hyperlink to jump to the worksheet within the
same workbook? is there such a thing?

"Conan Kelly" wrote:

Todd,

In XL 2003 (&2002) (if you need 2007, you'll have to get that from someone
else, HELP, or search for it):

1. Select the cell that has the formula
2. Tools Formula Auditing Trace Precedents
(you can also show the Formula Auditing toolbar so all of the functions are
just a click away)
3. Arrows will be displayed from each cell/range referenced in the
formula to the cell you were on, containing the formula.
(all references to other sheets will have one arrow going to an
icon.....external references)
4. double-click the arrow to move between the referenced cell and the
cell w/ the formula
(When clicking the external references arrow, a "Go To" dialog will pop up
listing all external references in the formula...double-click the reference
you want to go to or click on it once and click the OK button)

After you are done, you can erase all arrows, or you can erase just the ones
for the selected cell (also in Formula Auditing)

HTH,

Conan






"Todd" wrote in message
...
I'm creating a large spreadsheet, made up of many, many individual
worksheets. The information captured on each worksheet is summarized on
a
'Summary Sheet' for ease of tracking.

For example, the information manually entered on Tab 1, Tab 2, Tab 3 will
be
Summarized on the first tab of the workbook, which is the 'Summary Sheet'

Eventually, there will be so many individual worksheets it will be
difficult
to find the individual sheet to update it as necessary.

Is there a way, to jump to the appropriate worksheet from the 'Summary
Sheet'?