Please Note: This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here: References to Hyperlinks aren't Hyperlinks.
Written by Allen Wyatt (last updated June 8, 2024)
This tip applies to Excel 97, 2000, 2002, and 2003
If you have a hyperlink in a cell (such as cell A1) and then you use a formula in another cell that references that hyperlink, the result of that formula is not a hyperlink. For instance, suppose cell B1 contains this simple formula:
=A1
The result of that formula will not be a hyperlink, even if cell A1 contains a hyperlink. The reason is that the formula extracts the value of the referenced cell, which is the text displayed in A1. If what is displayed in cell A1 is a URL, then you could modify your formula just a bit to result in a hyperlink:
=HYPERLINK(A1)
If cell A1 does not contain a URL, or if it is a hyperlink where the displayed text is different then the underlying URL, then the HYPERLINK function won't work as expected.
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3282) applies to Microsoft Excel 97, 2000, 2002, and 2003. You can find a version of this tip for the ribbon interface of Excel (Excel 2007 and later) here: References to Hyperlinks aren't Hyperlinks.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel Data Analysis and Business Modeling today!
When you create a worksheet that is destined for viewing on the Web, you will want to specify the monitor resolution you ...
Discover MoreWhen you add a hyperlink to a worksheet, it consists of a minimum of two parts: display text and URL address. If you have ...
Discover MoreIs your worksheet information destined for a Web page? Here's how you can specify the fonts that should be used when ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the menu interface (Excel 97, Excel 2000, Excel 2002, or Excel 2003)? This site is for you! If you use a later version of Excel, visit our ExcelTips site focusing on the ribbon interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2026 Sharon Parq Associates, Inc.
Please Note:
This article is written for users of the following Microsoft Excel versions: 97, 2000, 2002, and 2003. If you are using a later version (Excel 2007 or later), this tip may not work for you. For a version of this tip written specifically for later versions of Excel, click here:
Comments