XL: Error Message Appears When You Change Link Source

 Last reviewed: January 9, 1998
Article ID: Q168583
The information in this article applies to:
  • Microsoft Excel 97 for Windows
  • Microsoft Excel for Windows 95, version 7.0

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 greater than 122 characters.

RESOLUTION

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

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

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 : xlformula xlui kberrmsg
Version : WINDOWS:7.0,97
Platform : WINDOWS
Issue type : kbprb
Solution Type : kbworkaround

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: January 9, 1998
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.