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

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

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

Error when processing filtered data

Due to an issue on the Google Sheets side, some pieces of the code of the add-ons don't work with filtered rows.

Current solution: Turn off the filter before running the add-on.

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.

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.

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

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

The problem has appeared recently on the Google side and is most likely connected to migrating to G Suite Marketplace from Chrome Web Store.

Current solution: Go to G Suite Marketplace and install the tool from there.

Tip. No worries, G Suite doesn't have to be paid for.

After that, scroll down to the bottom of the left panel in G Suite Marketplace and click Manage Apps:
Manage apps in G Suite Marketplace.
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.

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
mark van den bergen says:
April 16, 2019 at 9:16 am

I was hoping power tools could convert this formula to values
=VLOOKUP(A8,N:AR,4,false)
Converted to values should return an image thumbnail something like this:
=IMAGE("https://drive.google.com/uc?id=1blakDlwDEkxVq99cO9-lPbHMublabla")
But unfortunately powertools returns a blank cell.

Reply

Thank you for contacting us, Mark.
Could you please share a small sample spreadsheet with us (support@4-bits.com) with your source data and the result you expect to get? I kindly ask you to shorten the table(s) to 10-20 rows. We'll look into your task and see if there are ways to solve it with our tools.
Thank you.

Reply

Hi,
I am just following your example above to calculate the coloured boxes.
However, it kept showing 1 for COUNTA and 0 for COUNT.
I used this
=COUNT(valuesByCellColor("red", A8, M4:M7))
=COUNT(valuesByColor("#00ff00", "#000000", M4:M7))
Both does not work

Reply

Hi Bloom,

What example are you referring to?
Our tool creates valuesByColor function, not valuesByCellColor. Also, COUNT checks for cells with numeric records only. To make the formula consider textual and other cells as well, please use COUNTA.

If you're still unable to get it to work, for us to be able to help you, please share a sample spreadsheet with us (support@4-bits.com) with your source data and the result you expect to get. Please shorten the table to 10-20 rows.
Note. We keep support@4-bits.com for file sharing only and don't monitor its Inbox. Please do not email there.

We'll look into your task. Thank you.

Reply
Peter Schmidt says:
May 27, 2019 at 4:42 am

Hi,

I have installed the powertools addon and wanted to remove empty columns and rows from all pages, but it does not do the job, just for the current page. Can it be done in bulk, so if I have 100 sheets in google sheets then it removes all empty columns and sheets for all sheets?

Than you.
Petr

Reply

Hi Peter,

You are correct, the current version removes empty columns and rows only from the currently active sheet.

I will forward your request to our developers to check if it's technically possible to implement the feature.
Though I can't give you any timing, if you'd like, I can let you know when there's any news.

Reply
Bart Stuart Mortensen says:
July 12, 2019 at 3:47 pm

In the merge sheet add on, I am able to save the scenario. When I upgraded to power tools I am no longer able. Is there a fix planned for this?

Reply

Hello Bart,

At the moment, scenarios are available for single Merge Sheets only. We're working on transferring them to Power Tools, but I can't give you exact timing. I can email you back once scenarios are added there.

Please accept my sincere apologies for any inconvenience.

Reply

I just purchased the add on as my trial expired but it's not working.
It "works" but in the second column, it just duplicates the same exact first and last name in the second column. Please help!

Reply

Hello Erica,

Thank you for contacting us. Sorry to hear you've encountered difficulties with our add-on.

Our customer service assistant will reply to you by email.
Thank you for understanding.

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.