XL2000: References Are Missing After Moving Files from Windows to Macintosh (214333)
The information in this article applies to:
This article was previously published under Q214333 SYMPTOMS
When you open a workbook, references may be listed as missing in the References dialog box in the Visual Basic Editor. The references are listed as missing even though the referenced files are stored in the correct location and have not been moved, renamed, or deleted.
This may cause problems if you run Visual Basic macros that use the
referenced files.
CAUSE
This problem may occur when the following conditions are true:
- The workbook contains a reference to a file (workbook, add-in, type
library, and so on) that is stored on a network server that is
accessible to computers running Microsoft Windows or the Macintosh
operating system.
-and-
-
The referenced file is not stored in the same folder as the workbook.
-and-
-
At various times, you open the workbook in both Microsoft Excel 2000 for Windows and Microsoft Excel 98 Macintosh Edition.
Specifically, the problem occurs because the different versions of Excel do not always properly handle the transition from the Universal Naming Convention (UNC) in Windows (such as \\Server\Files\User001) to the Macintosh path convention (Files:User001). Because of this problem, references to files may be damaged when you move a workbook from Microsoft Excel for Windows to Microsoft Excel for the Macintosh or vice-versa.
To see an example of this problem, see the "More Information" section in this article.
WORKAROUND
To work around this problem, store the referenced files in the same folder
as the workbook that references them. If the files and the workbook are in the same folder, the references are not listed as missing when you open
the workbook.
NOTE: If you manually correct the missing references in the References dialog box, the problem may occur again the next time you open the workbook.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. REFERENCESFor additional information about references in Microsoft Excel, click the article number below
to view the article in the Microsoft Knowledge Base:
214333 XL2000: References Are Missing After Moving Files from Windows to Macintosh
Modification Type: | Major | Last Reviewed: | 9/27/2003 |
---|
Keywords: | kbbug kbinterop kbpending KB214333 |
---|
|