Fix an OLE Server Registration Error in Microsoft Access
Question details
Resolve an OLE server error when an Access form exports a report to Excel after an Office migration.

- Product
- Microsoft Access 2016 and Microsoft Excel
- Device & OS
- not provided
- Scenario
- A database migrated from Office 2010 to Microsoft 365 uses a form to generate an Excel report.
- Observed behavior
- Access displays an OLE server error when the form generates the report.
Identify the form and button used to generate the Excel report, and check that you can open the form in Design View. Note the installed Office version and build, since the same macro setting may behave differently between builds.
Turn off Auto Start in the export macro
Use this fix if the form's embedded macro exports the report with ExportWithFormatting and has Auto Start enabled.
In the Access Navigation Pane, right-click the form that generates the report and select Design View.
Select the button or control used to export the report. Open the Property Sheet, choose the Event tab, and open its embedded click-event macro.
Find the ExportWithFormatting action and change its Auto Start property from Yes to No. Save the macro and the form.
Open the form in Form View and use the export button again. If the export succeeds, open the resulting file in Excel.

Identify the application associated with an OLE object
Inspect the OLE object's source if the error persists or the form uses an embedded object.
Open exported Excel reports with WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface and Microsoft Office format compatibility, making it easy to move exported reports into a new workflow. It does not fix Access OLE registration errors or run Access forms and macros.

Frequently Asked Questions
Where is the Auto Start setting in Access?
Open the form in Design View, select the export control, and use the Property Sheet's Event tab to open its embedded macro. Look for Auto Start in the ExportWithFormatting action.
What happens when I set Auto Start to No?
Access will not automatically open the exported file after the export. Open the resulting file manually in Excel to check the report.
How can I tell which application is associated with an OLE object?
In the form's Design View, check the OLE control's Control Source in the Property Sheet. Then inspect that field in the underlying table's Datasheet View for clues about the associated application.
Can WPS Office fix the Access OLE server error?
No. The error must be troubleshot in Access and its associated Office applications. WPS Spreadsheets can open a compatible Excel report after it has been exported.




