Fix Sage 50 Report Exports to Excel in Microsoft 365
Question details
The user needs to export Sage 50 reports to Excel after installing Microsoft 365 Business.
- Product
- Sage 50 and Microsoft Excel in Microsoft 365 Business
- Device & OS
- not provided
- Scenario
- A user wants to send a Sage 50 report directly to Excel using a Microsoft 365 Business installation.
- Observed behavior
- Sage 50 may fail to send reports to Excel after Microsoft 365 Business is installed.
Note your Sage 50 edition and version, and open Excel to check your Microsoft 365 installation details. Have any export error message available when checking compatibility with Sage.
Check Sage 50 compatibility and install available updates
Use this approach to determine whether your Sage 50 version supports your Microsoft 365 installation.
In Excel, select File > Account and look under Product Information for Microsoft 365 and Click-to-Run details. Select About Excel to check the version and whether it is 32-bit or 64-bit.
In Sage 50, open Help > About, or the equivalent About screen for your edition, and note the product version and edition.
Check Sage's compatibility information for your specific Sage 50 edition and version, or contact Sage Support. Ask whether your Microsoft 365 version, installation type, and Excel bitness are supported for report exports.
Use the update option provided in your Sage 50 edition, or follow Sage Support's instructions to install a compatible update. Reopen Sage 50 and try sending the report to Excel again.

Export the report to a file and open it in Excel
Try this workaround if your Sage 50 report offers a file export format that Excel can open.
Open exported reports with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with spreadsheet files. Its format compatibility makes it easy to move existing Office documents into WPS. It does not fix Sage 50's direct Excel integration.

Frequently Asked Questions
How do I check whether Excel uses Click-to-Run?
In Excel, go to File > Account and look under Product Information for Click-to-Run details. The wording may vary by version.
Can I install an MSI version of Microsoft 365 Business instead?
Microsoft 365 is normally installed using Click-to-Run, and an MSI version may not be available for your subscription. Ask Sage which Office installations are supported by your Sage 50 version before making changes.
Where can I find my Excel version and bitness?
In Excel, select File > Account > About Excel. The About window shows the version and whether Excel is 32-bit or 64-bit.
Can I view a Sage 50 report without sending it directly to Excel?
If the report offers an Export or Save As option, save it in a supported format such as CSV and open it from Excel using File > Open. Available formats vary by Sage 50 edition and report.




