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.

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".

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