Spreadsheets Error: Exceeded Maximum Execution Time

Spreadsheets Error: Exceeded Maximum Execution Time

This article will assist you with the following error:

Exceeded maximum execution time



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.

Solution

  1. 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.
  2. You can also reduce the number or complexity of the formulas used in your spreadsheet(s).


    Still having issues?
    Send us a ticket and we will get back to you.
      • Related Articles

      • Report a Different Time Zone in Spreadsheets

        When reporting your data with our spreadsheets addon, you may want to adjust the date and time reported to account for a timezone offset. This article will show you how to use a formula to adjust the reported date and time in Sheets. Some connectors ...
      • Google Sheets Error: "Exception: You do not have permission to access the requested document."

        This article will assist you with the following error: "Exception: You do not have permission to access the requested document." Cause This error can occur when you are logged into two or more Google accounts while using the spreadsheets add-on. ...
      • Unable to Schedule Refresh in Google Sheets

        This article will address the following error: Unable to schedule refresh in Google Sheets. Error shown is "Exception: Bad Value." Cause Google Sheets requires you to set a Time Zone. Solution Go to File > Settings. Choose the appropriate time zone ...
      • Installing the Power My Analytics Add-on for Google Sheets

        If you'd like to merge and manipulate data from popular sales and advertising platforms with Google Sheets to create insightful and automated reporting, follow the instructions below to install and launch the Power My Analytics Sheets Data Connector. ...
      • Google Account Disconnects When Using Google Workspace

        This article will assist you with the following errors: In Looker Studio: Please click "REFRESH AUTHENTICATION" and reauthenticate with Power My Analytics/Authorization Error - Access Token Expired, please disconnect and reconnect In Google Sheets: ...