Known issues – add-ons for Google Sheets

Below you can find a list of possible issues that can occur when working with Google Sheets add-ons. They are caused by current technical limitations on Google end. We are looking for ways to go around them, though in some cases the only thing we can do is wait for bug fixes or new possibilities for third-party developers. We appreciate your patience and understanding.

If the problem you are having is not described here, please use the contact form at the bottom of the page to write to us or email straight to support@ablebits.com

Report a new issue

Installation issues

The only option in the add-on menu is Help

Sometimes when you're trying to run the add-on, the only option you can see in the drop-down menu is Help. This is usually caused by Google internal problems.

Current solution: Reload the spreadsheet a few times and see if other options appear. If this doesn't help, email us to support@ablebits.com

Issue-prone add-ons: All Google Sheets add-ons.

drive.google.com refused to connect

This problem is caused by an issue on the side of Google when you are logged in under more than one account.

Current solution: Sign out of all accounts and log back in only under the account you used to grant permissions to the add-on. If this doesn't help, email us to support@ablebits.com

Issue-prone add-ons: All Google Sheets add-ons.

Blank sidebar when you start the add-on

This issue is known for all add-ons for Google Sheets. Most often it occurs in Safari browser. Some technical peculiarities of the way Google Sheets add-ons are made are causing this.

Possible solution: Try to update your browser or change it to Google Chrome.

Issue-prone add-ons: All Google Sheets add-ons.

The add-on doesn't install at the first attempt

This is a known Google problem that affects all add-ons in Google Workspace Marketplace (formerly G Suite Marketplace). You click Install, allow permissions, see the spinning arrows working, then they disappear but the page still says Install. There's no confirmation of the successfull installation whatsoever.

Current solution: Since we can't control the problem, we have to ask you to try and install the add-on a few more times.

Before you do so, make sure to sign out and log back into only one Google account – it often helps.

Also, please try to install from both the Add-ons > Get add-ons menu in your spreadsheet and from a Google Workspace Marketplace page in a new browser tab.

If the installation still doesn't go through, please report the problem to Google – this will help them in debugging. Just click the icon with a question mark at the upper-right corner of the installation page/window and select Send Feedback:
Send feedback in Google Workspace Marketplace.

Issue-prone add-ons: All Google Sheets add-ons.

I removed the add-on but it's still in the list of my tools

First, check if you share you spreadsheet with someone. If so, the Add-ons menu will show all add-ons used by all users in this document. It's just the way spreadsheets work.

If you don't share the spreadsheet with anyone, contact your Admin to make sure the add-on is not installed to your entire domain. If it is, please ask your Admin to remove the tool for you or simply change its settings.

If the add-on is not installed to the entire domain, go to Google Workspace Marketplace and install the tool from there.

Tip. No worries, Google Workspace doesn't have to be paid for.

After that, click the gear wheel icon at the upper-right corner of the page (next to your account picture) and pick Manage Apps:
Manage apps in Google Workspace Marketplace.

If the tool is in the list, click the icon with three dots on its image and choose Uninstall.

Then return to your spreadsheet and remove the add-on once again the standard way.
If this doesn't help, email us to support@ablebits.com

Issue-prone add-ons: All Google Sheets add-ons.

I can't make the add-on run automatically

Unfortunately, at the moment it's impossible to run our add-ons automatically.

Current solution: Our Remove Duplicate Rows and Merge Sheets now support scenarios — the sets of options that you choose often. This lets you automate repetitive tasks and process data in a click.

All you need to do is click one button to save these settings, name this scenario, and run it from the menu later. You will find all the details concerning scenarios on the add-ons' help pages.

Issue-prone add-ons: All Google Sheets add-ons.

Common issues related to data processing

The add-on doesn't work (the Next button is disabled, "working" arrows are spinning all the time, or there is no result)

This issue occurs if you are logged in under more than one Google account. It happens due to an issue with multiple Google accounts on Google side.

Possible solution: Please sign out and log back in with an account under which you want to work with your spreadsheet.

Issue-prone add-ons: All Google Sheets add-ons.

The add-on cannot paste the formula: limit for 50k chars in a cell

When you insert the result as a formula with some tools, the length of the formula depends on the number of sheets/files you refer to. In some cases (mainly with Combine Sheets and Consolidate Sheets), the formula may exceed the maximum of 50,000 characters in a single cell. To our regret, Google Sheets prevents such long inputs into cells.

Current solution: Process data by parts.

Issue-prone add-ons: Combine Sheets, Consolidate Sheets, Function by Color, Multiple VLOOKUP Matches, Power Tools, IF Formula Builder.

All records starting with a single quote (') are processed as numbers.

Unfortunately, this limitation occurs for all add-ons in Google Sheets and we cannot bypass it. Thus, if you enter '12 in your cell, the record will be turned into 12 and processed accordingly.

Issue-prone add-ons: All Google Sheets add-ons.

Custom functions are not updated automatically

Caused by a known bug in Google Sheets, unless you change a value in one of the cells, we can't automatically update the formulas we insert.

Current solution: Function by Color introduced the Refresh option to update all custom formulas it inserts into your sheet in one go.

Issue-prone add-ons: Function by Color, Power Tools.

Scenarios don't appear in the Add-ons menu

When you place the results into a new spreadsheet, you won't see your saved scenarios in that file under the Add-ons drop-down.

Current solution: Run the add-on once in that new spreadsheet and all your scenarios will appear in the Google Sheets menu.

Issue-prone add-ons: Remove Duplicates, Merge Sheets, Power Tools.

Dates cannot be processed

When the add-ons process dates, they don't get them in the same way you see them. When the add-on script gets an array of data to process, it receives the date as a combination of numeric characters that differ from the date format displayed to you in the sheet, e.g. the script sees "Mon May 05 2014 00:00:00 GMT" instead of "5/5/2014". This is the reason why neither search nor replacement will return correct results. And that's why many of our add-ons do not process dates – to avoid data corruption.

Issue-prone add-ons: Advanced Find and Replace, Merge Values, Modify tools in Power Tools.

No results with merged cells in the range

There is no technical possibility for the add-on to find out if the selection contains merged data, which prevents us from showing you a message with an explanation. When the script processes your data by row or column and it encounters merged cells in the selection, it can't correctly fulfil the task and returns no results.

Possible solution: Select the option to Unmerge under Format > Merge cells prior to running the add-on.

Issue-prone add-ons: Power Tools.

The add-on gives a Server error

This is a very general error. It may be caused by exceeding the limit of 5 million cells in Google Sheets. If you have a large spreadsheet, you can check this by trying to duplicate the sheet with your data, you will see the error right away.

Current solution: Avoid the options that add cells and skip the option to create a backup copy of the sheet.

Issue-prone add-ons: All Google Sheets add-ons.

The add-on returns no results

When you work with a large range of various data and if you have a very slow Internet connection, the add-on may hit Google's 360-second time limit for operation. Our developers work hard to avoid such issues, please let us know if you encounter it with any Ablebits tools.

Issue-prone add-ons: Advanced Find and Replace, Table Styles.

Specific issues with some add-ons

The Clear tool doesn't remove comments

When you run the option Clear all, it removes everything but comments from cells since Google Spreadsheet Service doesn't allow to access and manage comments at the moment.

Issue-prone add-ons: Power Tools.

Function by Color doesn't work

A lack of locale in your spreadsheet may prevent the function from calculating the results as it doesn't know what delimiter should be used.

Possible solution: Set the locale in File > Spreadsheet settings.

Issue-prone add-ons: Function by Color, Power Tools.

Function by Color counts cells with an apostrophe (') as blanks

Since Google Sheets doesn't offer the instruments required to see if cells contain only an apostrophe, such cells are treated as completely empty and are not included in the result.

Issue-prone add-ons: Function by Color, Power Tools.

Function by Color cannot process large data sets (over 200K cells) with one formula

Due to some Google Sheets limits for custom functions, our Function by Color tool cannot process large data sets (over 200K cells) with one formula.

Current solution: Process your data in smaller parts with a few Function by Color formulas. You can sum their results afterwards if needed.

Issue-prone add-ons: Function by Color, Power Tools.

Function by Color freezes when trying to refresh results for numerous formulas. Some valuesByColor formulas disappear

Due to Google limitations for custom functions, in order to recalculate formulas there has to be some change made in the values. Instead, our Function by Color temporarily deletes its own formulas and inserts them back triggering the recalculation. Once the process is over, all formulas are back and updated.

Nevertheless, in rare cases with too many formulas, the add-on freezes unable to return all results.

Current solution: Restore your data through File > Version history and process data in smaller parts.

Issue-prone add-ons: Function by Color, Power Tools.

Function by Color doesn't support Theme colors

Theme colors is a relatively new formatting tool in Google Sheets. Unfortunately, at the moment its algorithm doesn't allow our add-on to get all colors in the selected range.

Current solution: Use standard Fill colors rather than Theme colors.

Issue-prone add-ons: Function by Color, Power Tools.

Multiple VLOOKUP Matches returns incorrect results

When looking for matches in a column with both dates and time, the add-on pulls incorrect/not all matches.

Current solution: Apply the same number format to the entire column with your records: Format > Number > Date time in the Google Sheets menu.

Otherwise, with values formatted differently within the column, for instance, pure dates (9/27/2019) and date and time (9/27/2019 9:00 AM), the add-on won't be able to process data correctly.

Issue-prone add-ons: Multiple VLOOKUP Matches, Power Tools.

Table Styles can't pick some of your formatting

Access to some formatting options is limited in the API that Google provides. This is why Table Styles add-on can't "see" the borders you have; it can't set any color but black for the added borders for the same reason. Similar limitations do not let it recognize text alignment in the selected range. There is also no technical way to see whether the text is wrapped when the add-on tries to pick the selected style.

Though there are no possibilities for us to identify the above, we can still let you add, save and apply these options when creating table styles.

Issue-prone add-ons: Table Styles.