# Spreadsheets Error: Exceeded Maximum Execution Time

This article will assist you with the following error:

**Exceeded maximum execution time**

![](https://knowledge.powermyanalytics.com/application/troubleshooting/images/spreadsheets-error-exceeded-maximum-execution-time-1.png)

## Cause

When using the spreadsheets add-on for Google Sheets or Excel, the add-on may time out with this error when you have a large number of reports in your spreadsheet. This error can also be caused by the use of many formulas in your spreadsheet, which can delay your reports from running.

In Google Sheets, the add-on runs on Google Apps Script, which limits each run to 6 minutes, and a scheduled refresh updates every report in the spreadsheet in one run. A spreadsheet that refreshed without trouble for months can start reaching the limit as its reports and formulas grow.

## Solution

- Reduce the number of reports in your spreadsheet by splitting the reports across multiple spreadsheets. For example, instead of one spreadsheet containing 100 reports, you could use four spreadsheets with each containing 25 reports.
- You can also reduce the number or complexity of the formulas used in your spreadsheet(s).
- Move formulas that use the report data to a separate Google Sheets document, and bring the data in with the IMPORTRANGE function. See [What to Do When a Report Is Loading Slowly](https://knowledge.powermyanalytics.com/application/troubleshooting/what-to-do-when-a-report-is-loading-slowly/#google-sheets).
- Split long date ranges into reports by period (for example, one report for last year and one for this year), and move reports for past periods to a spreadsheet without a scheduled refresh.

If this error stops a scheduled refresh, see [Google Sheets Scheduled Refresh Not Running or Failing](https://knowledge.powermyanalytics.com/application/troubleshooting/google-sheets-scheduled-refresh-not-running/) for more ways to fix it.
