XL: Error Message Appears When You Change Link Source

ID: Q168583

The information in this article applies to:

SYMPTOMS

When you attempt to change the source of a link in Microsoft Excel, you may receive one of the following error messages:

Microsoft Excel 97

   Cannot link to the file

Microsoft Excel 7.0

   Cannot link to a chart

CAUSE

You may receive either of these error messages if you are trying to change a link to a file that has a name that is longer than 122 characters.

RESOLUTION

To resolve this problem, shorten the length of the file name to 122 characters or fewer.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

REFERENCES

For more information about creating links, click the Index tab in Microsoft Excel Help, type the following text 

   links, creating
and then double-click the selected text to go to the "Create links to connect to data and files" topic.

Additional query words: XL97 

Keywords          : kberrmsg xlui xlformula 
Version           : WINDOWS:7.0,97
Platform          : WINDOWS
Issue type        : kbprb

Last Reviewed: January 8, 1999