ACC1x: OLE Excel Format Changes When Updated in Microsoft Access

ID: Q92650

The information in this article applies to:

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.


The OLE Object now displays row and column headings. You may need to resize the OLE Object to see the updated contents of cell A1. 


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

Last Reviewed: March 12, 1999