Microsoft KB Archive/824172

= &quot;Unable to Read File&quot; Error Message When You Open an Excel Workbook That Contains Links to Other Excel Workbooks =

Article ID: 824172

Article Last Modified on 9/22/2003

-

APPLIES TO


 * Microsoft Office Access 2003
 * Microsoft Access 2002 Standard Edition
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article applies to a Microsoft Access database (.mdb) and a Microsoft Access project (.adp).

Novice: Requires knowledge of the user interface on single-user computers.



SYMPTOMS
When you open a workbook in Excel, and the workbook contains links to other Excel workbooks that are generated when a report in Access is exported to Excel, you may receive the following error message when you update the links in the workbook:

Unable to read file.



WORKAROUND
To work around this problem, open all the linked Excel workbooks before you open the workbook that contains the links.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce the Behavior
 Start Microsoft Access. Open the Northwind.mdb sample database. In the database window, under Objects, click Reports. In the right pane, right-click the Customer Labels report, and then click Export. In the Export Report 'Customer Labels' To dialog box, select one of the following from the Save as type list:  If you are using Microsoft Access 2002, select Microsoft Excel 97-2002 (*.xls).</li> If you are using Microsoft Office Access 2003, select Microsoft Excel 97-2003 (*.xls).</li></ul> </li> Click Export.</li> Start Excel, and then create a new workbook.</li> Link a cell in the workbook to the exported Excel workbook.

For example, if the exported Excel workbook is stored in C:\, type the following in the Formula Bar field that corresponds to the cell that is to be linked in the new Excel workbook:

='C:\[Customer Labels.xls]Customer Labels'!D4

</li> Save the Excel workbook as TestBook.xls.</li> Open the TestBook.xls file.</li> In the Update the links in the Excel workbook dialog box, click Update.</li></ol>

Additional query words: ACC2002 ACC2003

Keywords: kbreport kbexport kberrmsg kbprb KB824172

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.