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 below to write to us or email straight to support@ablebits.com

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.

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

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: Sum by Color tool introduced the Refresh option to update all custom formulas it inserts into your sheet in one go.

Issue-prone add-ons: Power Tools.

It is not possible to work with non-adjacent ranges

Google Spreadsheet Service doesn't provide a way for the scripts to access multiple selected ranges at the moment, that's why you will always see the results for the last selected range. We are looking forward to adding this functionality to many add-ons.

Issue-prone add-ons: All add-ons; Merge Values, Random Generator, Power Tools among them.

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 differs 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. Most our add-ons do not process dates to avoid data corruption.

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

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 processesed accordingly.

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

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 fulfill 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 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 an 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.

The add-on gives a Server error

This is a very general error. It may be caused by exceeding the limit of 2 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.

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.

Change case doesn't work

Capitalize and Sentence case. don't work if your data already contains any words in capitals.

Current solution: Please apply lowercase first. This was made intentionally in order not to corrupt any acronyms you may have. Though it does take one extra click to first turn text to lowercase, we believe it is easier than restoring words that were supposed to be in uppercase.

Issue-prone add-ons: Power Tools.

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 now supports scenarios - the sets of options that you choose often. This lets you automate repetitive tasks and check for duplicates 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-on's help page.

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

Responses

Alejandro Sanchez says:
February 19, 2019 at 6:59 pm

When using the find and replace tool in the power tools product, it has been telling me for all queries no matter how small or large, that there is no matching data found. But there is data. Do you know what might be goign on? Thanks

Reply

Hello Alejandro,

Please note that there is currently an issue on the side of Google Sheets that occurs when you are logged in under more than one account. I kindly ask you to sign out and log back in only under the account you used to grant permissions to the add-on.

If this doesn’t solve the problem, would it be possible for you to share a sample sheet with a couple of lines of your data with support@4-bits.com for testing?

We'll do our best to help you.

Reply

I installed two addons in my spreadsheet and now I can not delete them. The addons are "Find Fuzzy Matches" and "Flookup", thanks for your time.

Reply

Hi José,
Thank you for your question.

To uninstall add-ons from your Google Sheets, open any spreadsheet, go to Add-ons > Manage add-on, find the tool in the list and choose to Manage > Remove it.

If you need any further assistance, please email us to support@ablebits.com.
Thank you.

Reply
Alexander Ledig says:
February 25, 2019 at 1:11 pm

there is no place to insert license key: Select Add-ons > Power Tools > Enter license key in the Google Sheets menu.
this just doesnt exist

Reply

Hello Alexander,
Thank you for contacting us.

If you don't see the Enter license key option in the menu, most likely the add-on is already unlocked. Please run the tool and click the key icon at its bottom - you should see your license information there.
Otherwise, please email us to support@ablebits.com with the screenshots of the issue.
We'll do our best to help you activate.

Reply
Digamber Singh says:
March 13, 2019 at 9:17 am

Add Reminders Google Sheets add-on encountered a problem in your setting, but

Reply

Hello Digamber,

I'm sorry but Add Reminders is not our add-on. Please contact the tool's support team regarding the issue: support@add-reminders.com
Thank you.

Reply

Ask a question (posted publicly)

If you have any questions or issues with this add-in, please feel free to post your concerns in the comments area. As soon as we answer, a notification message will be sent to your e-mail. If you do not want to share your thoughts in public, please contact us at support@ablebits.com.
Privacy policy Terms of use Contact us

Microsoft and the Office logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.