ACC1x: OLE Excel Format Changes When Updated in Microsoft Access

• Microsoft Access versions 1.0, 1.1

SYMPTOMS

New OLE objects created in Microsoft Excel version 4.0 are displayed without row or column headings in Microsoft Access version 1.x. Once the object has been updated, the display changes and row and column headings are displayed.

STATUS

This behavior no longer occurs in applications using OLE 2.0, such as Microsoft Access version 2.0 and Microsoft Excel version 5.0.

MORE INFORMATION

Steps To Reproduce Behavior

1. Start Microsoft Excel.



2. Enter Test in cell A1.



3. Select cell A1 and choose Copy from the Edit menu.



4. Start Microsoft Access and open a database.



5. Create a new form and choose Paste from the Edit menu. This creates an OLE Object which displays cell A1.



6. Double-click on the OLE Object to activate Excel.



7. Modify the contents of cell A1.



8. From the File menu choose Update.



9. Activate Microsoft Access.

Keywords : IntpOle
Version : 1.0 1.1
Platform : WINDOWS
Issue type : kbprb