Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Error opening file that refers to shortcut


View products that this article applies to.

This article was previously published under Q213650
For a Microsoft Excel 97 and earlier versions of Excel version of this article, see 132976 (http://support.microsoft.com/kb/132976/ ) .
For a Microsoft Excel 97 and earlier versions of Excel version of this article, see 132976 (http://support.microsoft.com/kb/132976/ ) .

↑ Back to the top


Symptoms

In Microsoft Excel, when you open a workbook that contains a reference to a shortcut to a workbook, one of the following symptoms occurs:
  • If the workbook that you open contains the defined name "Auto_Open" that refers to a macro in the shortcut to the workbook, you receive the following error message
    Cannot find 'filename'!macro, which has been assigned to run each time [book] is opened. Continuing could cause errors. Cancel opening [book]?
    where filename is the name of the shortcut to the workbook that contains your macro, macro is the name of the macro you want to run automatically, book is the name of the workbook that you are opening that contains the Auto_Open defined name.
  • If the workbook that you open contains a link to a cell in the shortcut to the workbook, the File Not Found dialog box appears (if you choose to reestablish the link).

↑ Back to the top


Cause

In Microsoft Windows, you can create a shortcut to any program, document, or printer, and put this shortcut in any folder or on the desktop. This makes it easy to access the objects that you use most frequently. However, if you create a link or reference to a shortcut to a workbook in a Microsoft Excel workbook, the behavior described in the "Symptoms" section occurs because Microsoft Excel does not recognize the workbook that the shortcut refers to.

↑ Back to the top


Workaround

To work around this behavior, create the link or reference to the original workbook instead of to a shortcut to the workbook.

↑ Back to the top


Keywords: KB213650, kbprogramming, kbprb, kbpending, kberrmsg

↑ Back to the top

Article Info
Article ID : 213650
Revision : 5
Created on : 1/24/2007
Published on : 1/24/2007
Exists online : False
Views : 378