ACC1x: OLE Excel Format Changes When Updated in MS Access

 Last reviewed: August 6, 1997
Article ID: Q92650
The information in this article applies to:
  • 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.

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
Hardware          : x86
Issue type        : kbprb
Solution Type     : kbfix

================================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: August 6, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.