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

      • 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: ...
      • How to Connect a Google Sheets Report to Looker Studio

        In this article, we'll show you how to use Google Sheets as a data source for Looker Studio. Learn all about connecting your spreadsheet, choosing field types, and integrating your data into Looker Studio charts for visually engaging presentations. ...
      • Google Sheets Data Integration Guide

        Integrate your marketing data into Google Sheets to build custom reports and dashboards. This guide will walk through how to install the Sheets add-on, create reports, edit reports, refresh data, and more. Install the Google Sheets Add-on To install ...