Hyperlink to Another Sheet

  • Thread starter Thread starter Chris Guimbellot
  • Start date Start date
C

Chris Guimbellot

Hello,

Excel 2000.

I am trying to use the Hyperlink function to create a link to a cell in
another sheet in the same workbook. Here is the function I have used:

=HYPERLINK("amenities!A1","GO")

When I click the link, I get the "Cannot open the specified file message.
For what its worth, I have tried the following, but I still get the same
message:

=HYPERLINK("[amenities]!A1","GO")
=HYPERLINK("[In-House Web Analysis]amenities!A1","GO")
=HYPERLINK("[In-House Web Analysis] amenities!A1","GO")
=HYPERLINK(amenities!A1,"GO") (No error message, but the link didn't work)

I have not idea what to do. Any ideas? Thanks,

Chris
 
Frank,

Thanks for the help, when I try that and then tab out of the cell, it
reverts clears the ' marks. Am I doing something wrong? Thanks,

Chris

Frank Kabel said:
Hi
try
=HYPERLINK('amenities'!A1,"GO")

--
Regards
Frank Kabel
Frankfurt, Germany

Chris Guimbellot said:
Hello,

Excel 2000.

I am trying to use the Hyperlink function to create a link to a cell in
another sheet in the same workbook. Here is the function I have used:

=HYPERLINK("amenities!A1","GO")

When I click the link, I get the "Cannot open the specified file message.
For what its worth, I have tried the following, but I still get the same
message:

=HYPERLINK("[amenities]!A1","GO")
=HYPERLINK("[In-House Web Analysis]amenities!A1","GO")
=HYPERLINK("[In-House Web Analysis] amenities!A1","GO")
=HYPERLINK(amenities!A1,"GO") (No error message, but the link didn't work)

I have not idea what to do. Any ideas? Thanks,

Chris
Click to expand...
Click to expand...
 
Hi
no that's o.k. If your worksheet name does not contain blanks the
apostrophes are not required and Excel deletes them

--
Regards
Frank Kabel
Frankfurt, Germany

Chris Guimbellot said:
Frank,

Thanks for the help, when I try that and then tab out of the cell, it
reverts clears the ' marks. Am I doing something wrong? Thanks,

Chris

Frank Kabel said:
Hi
try
=HYPERLINK('amenities'!A1,"GO")

--
Regards
Frank Kabel
Frankfurt, Germany

Newsbeitrag news:[email protected]...
Hello,

Excel 2000.

I am trying to use the Hyperlink function to create a link to a
Click to expand...
cell
in
another sheet in the same workbook. Here is the function I have used:

=HYPERLINK("amenities!A1","GO")

When I click the link, I get the "Cannot open the specified file message.
For what its worth, I have tried the following, but I still get
Click to expand...
the
same
message:

=HYPERLINK("[amenities]!A1","GO")
=HYPERLINK("[In-House Web Analysis]amenities!A1","GO")
=HYPERLINK("[In-House Web Analysis] amenities!A1","GO")
=HYPERLINK(amenities!A1,"GO") (No error message, but the link
Click to expand...
didn't
work)
I have not idea what to do. Any ideas? Thanks,

Chris
Click to expand...
Click to expand...
Click to expand...
 
Does *not* work for me in Excel 2000 without the bookname,
would work Excel 2002 above as I understand it.
=HYPERLINK(C5, C5)
=HYPERLINK('amenities'!A1,"GO")
=HYPERLINK(Sheet34!E6,Sheet34!E6)
=HYPERLINK('my sheet'!E6,Sheet34!E9)

These work: in Excel 2000, and as I understand from Excel 97 and up
=HYPERLINK("#C5",C5)
=HYPERLINK("#Sheet34!E6",Sheet34!E6)
=HYPERLINK("#'My Sheet'!E6",Sheet34!E8)

But if you want to use the fill handle, you have to use something like this
in Excel 2000 (and Excel 97 as understood).
=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

All of this is on my webpage in more detail (with above ammendments)::
http://www.mvps.org/dmcritchie/excel/sheets.htm#hyperlink
 
Back
Top