Help and Support

Frequently asked questions about using links in Excel 2002 and in later versions of Excel

View products that this article applies to.
Article ID:293418
Last Review:January 31, 2007
Revision:2.1
This article was previously published under Q293418
On This Page

SUMMARY

In Microsoft Excel 2002 and in later versions of Excel, a link can be any of the following items:
•A reference to another workbook (sometimes called an external reference)
•A link to another program (sometimes called a remote reference)
•A link to data on the Internet, the World Wide Web, or your company intranet
Because data in another workbook, another program, or on the Internet may change and outdate the data in your workbook, there are options for controlling the updating of links.

This article lists some frequently asked questions and troubleshooting tips about how to use links in Excel 2002 and in later versions of Excel. The article also includes corresponding Microsoft Knowledge Base articles.

Back to the top

MORE INFORMATION

General

•How do I check the status of the external links in my workbook?
288940 (http://support.microsoft.com/kb/288940/) How to check and manage the status of links in Excel 2002 or later versions of Excel
•How do I turn off the reminder message to update links in my workbook?
826921 (http://support.microsoft.com/kb/826921/) How to control the startup message about updating linked workbooks in Excel 2002 and in later versions of Excel
•How do I prevent the automatic creation of hyperlinks?
291209 (http://support.microsoft.com/kb/291209/) How to prevent the automatic creation of hyperlinks

Back to the top

Troubleshooting

•Why am I still prompted to update links after I've broken the links in my workbook in Excel 2002 and in Microsoft Office Excel 2003?
288853 (http://support.microsoft.com/kb/288853/) Defined name not removed when you break a link
•Why do I receive an error message when I open a linked workbook?
291084 (http://support.microsoft.com/kb/291084/) Error opening workbook containing links to HTML workbook

Back to the top

APPLIES TO
•Microsoft Office Excel 2003
•Microsoft Excel 2002 Standard Edition

Back to the top

Keywords: 
kbhowto kbinfo KB293418

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.