Article ID: 293418 - Last Review: January 31, 2007 - Revision: 2.1

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

This article was previously published under Q293418

On This Page

Expand all | Collapse all

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.

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

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

APPLIES TO
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
Keywords: 
kbhowto kbinfo KB293418
 

Article Translations

 

Related Support Centers