Platform limits and requirements with Office Scripts
There are some platform limitations of which you should be aware when developing Office Scripts. This article details the browser support and data limits for Office Scripts for Excel.
Data limits
There are limits on how much Excel data can be transferred at once and how many individual Power Automate transactions can be conducted.
Excel
Excel on the web has the following limitations when making calls to the workbook through a script.
- Requests and responses are limited to 5MB.
- A range is limited to five million cells.
If you're encountering errors when dealing with large datasets, try using multiple smaller ranges instead of larger ranges. For an example, see the Write a large dataset sample. You can also use APIs like Range.getSpecialCells to target specific cells instead of large ranges.
Excel limits that aren't specific to Office Scripts can be found in the article Excel specifications and limits.
Power Automate
When using Office Scripts with Power Automate, each user is limited to 1,600 calls to the Run Script action per day. This limit resets at 12:00 AM UTC.
The Power Automate platform also has usage limitations, which can be found in the following articles.
- Limits and configuration in Power Automate
- Known issues and limitations for the Excel Online (Business) connector
Note
If you have a long-running script, be aware of the 120-second timeout for synchronous Power Automate operations. You'll need to either optimize your script or split your Excel automation into multiple scripts.
Teams support
Important
When using Excel with Teams, Office Scripts are only supported in Teams on the web (not Teams for Windows, Mac, iOS, or Android).
Third-party cookies for Excel on the web
Your browser needs third-party cookies enabled to show the Automate tab in Excel on the web. Check your browser settings if the tab isn't being displayed. If you're using a private browser session, you may need to re-enable this setting each time.
Note
Some browsers refer to this setting as "all cookies", instead of "third-party cookies".
How to adjust cookie settings in popular browsers
Cross-platform API support
Some Office Scripts APIs may not be supported by Excel for Windows or Excel for Mac, especially older builds. These include newer APIs and APIs for web-only features. If a script contains unsupported APIs, the Code Editor displays a warning. If you try to run such a script, it won't run and, instead, the Script Run Status task pane displays a warning message that says, "This script currently must be run on Excel for the web. Open the workbook in the browser then try again, or contact the script owner for help."
See also
Feedback
Submit and view feedback for