Fix Excel Online ExecuteRichApiRequest HTTP 500 Errors
Question details
Troubleshoot an Excel Online add-in that receives an HTTP 500 response from ExecuteRichApiRequest.

- Product
- Excel Online and Office Add-ins
- Device & OS
- not provided
- Scenario
- An add-in runs the same Excel API code in desktop Excel and Excel Online.
- Observed behavior
- The ExecuteRichApiRequest call returns HTTP 500 in Excel Online, while the code works in desktop Excel.
Identify the add-in operation that triggers the error and note the workbook size and affected range. Have a smaller test workbook ready so you can compare results.
Reduce the Excel Online request size
Use a smaller workbook and smaller batches to check whether the amount of data contributes to the error.
Open the add-in in Excel Online with a workbook containing a small sample of the affected data, then repeat the operation that failed.
In the add-in code, replace unnecessarily large range selections with the rows, columns, or properties the operation needs.
Update the add-in code to process smaller ranges in batches and call context.sync() between batches, then retest the operation in Excel Online.
Repeat the test with progressively larger ranges or workbooks to identify whether the failure appears at a particular workload.

Check Excel Online service health and request details
Use this approach if smaller requests still fail or the issue affects multiple workbooks.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Microsoft Office formats, making it easier to move everyday workbook tasks between applications. It does not fix Excel Online service errors.

Frequently Asked Questions
Does HTTP 500 mean my Excel add-in code is wrong?
Not necessarily. HTTP 500 indicates a server-side error, and a large request or a service issue may contribute. Test the add-in with a smaller workbook and inspect the failed request in your browser's Network panel.
Why does the add-in work in desktop Excel but fail online?
The web and desktop environments can handle workloads differently. Reduce the requested range and test smaller batches in Excel Online to see whether the amount of data affects the result.
How can I check whether Excel for the web has a service issue?
A Microsoft 365 administrator can open the Microsoft 365 admin center and check Health > Service health for relevant incidents.
What information should I include when reporting the error?
Include the time of the failure, steps to reproduce it, the affected operation, and any request or correlation ID visible in the browser's Network panel. Remove sensitive data before sharing logs.




