Microsoft KB Archive/177926

= ACC: Updates to Linked Excel Workbook Don't Appear in Excel =

Article ID: 177926

Article Last Modified on 1/22/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q177926



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



SYMPTOMS
Updates you make to a linked Microsoft Excel workbook do not show up when you open the workbook in Microsoft Excel 97.



CAUSE
The workbook you are linking to was saved in Microsoft Excel 97 in the "Microsoft Excel 97 & 5.0/95 Workbook" format.



RESOLUTION
If you need to link to a Microsoft Excel 97 workbook from Microsoft Access 97, do not save the workbook in the "Microsoft Excel 97 & 5.0/95 Workbook" format.



MORE INFORMATION
When Microsoft Access links to a Microsoft Excel workbook that has been saved in the "Microsoft Excel 97 & 5.0/95 Workbook" format, it only writes changes to the Microsoft Excel 95 version of the workbook.

Steps to Reproduce Behavior
  Create a workbook in Microsoft Excel 97 as follows:

     A1: abc A2: def  On the File menu, click Save As. In the File Name box, type Book1.xls. In the Save As Type box, select "Microsoft Excel 97 & 5.0/95 Workbook (*.xls)" and click OK. Quit Microsoft Excel.</li> In Microsoft Access 97, create a link to the Book1.xls file.</li> Change the abc in cell A1: to xyz.</li> Quit Microsoft Access.</li> Open Book1.xls in Microsoft Excel 97. Note that cell A1: still shows abc and not xyz. However, if you open the linked table in Microsoft Access, it will show xyz.</li></ol>

<div class="references_section">