FAQs about Ablebits add-ins for Microsoft Excel and Outlook

Responses

Arjan van Loon says:

January 5, 2022 at 4:22 pm

Is it also possible to activate the important e-mail plug-in on a Remote Desktop Services farm?
Or is it only supported on desktop OS?

Thanks, best regards,
Arjan

Daria Markelova (Ablebits Team) says:

January 5, 2022 at 5:50 pm

Hello Arjan,

Thank you for your questions.

If you are referring to the Important Mail Alert tool, please note that it is available only as a part of our Add-ins Collection for Outlook in two editions:
• Business edition, that allows corporate deployment via SCCM or GPO. You can install this edition using this direct link: https://www.ablebits.com/files/get.php?addin=ol-collection&f=free-trial
• For Terminal server users edition. You can download it using the link below and test how it works in your environment: https://www.ablebits.com/files/get.php?addin=ol-collection-tsu&f=free-trial

In case you have more questions, feel free to email us at support@ablebits.com.

Samuel Turner says:

March 12, 2021 at 4:18 pm

What is the difference between your 2016, 2018, and 2019 releases? I did not see a chart about differences and upgrade costs.

I like your Excel blog articles too!

Katerina Bespalaya (Ablebits Team) says:

March 12, 2021 at 4:47 pm

Hello Samuel,

Thank you for your feedback.

Sorry, we do not have a comparison chart showing the differences between the major versions of our software. Major upgrades generally come out when Microsoft releases an Office version or an update that requires great efforts from our team to support it or when some significant changes are made to the add-in. We also announce about major upgrades and critical updates on our blog:
https://www.ablebits.com/office-addins-blog/category/ablebits-news/

All minor updates and major upgrades are free during 2 years after the purchase. After that, you can buy the next major version at half of the regular price. You can send your current license key for our add-in to support@ablebits.com and we'll check if you are eligible for a free upgrade.

Feel free to contact us again if you have any other questions or need further assistance.

Rita Mest says:

November 4, 2020 at 4:09 pm

I was using AbleBits as recently as yesterday, but it has disappeared from my toolbar and I cannot get it to reappear. Excel Version 1902 (Office Suite 365ProPlus). AbleBits Ultimate Suite, purchased 12/2019.

It does appear in the Options -> Add ins in the Active list.

Please advise what additional steps I can take to have it appear in my toolbar. Thank you.

Aksana Pachkouskaya (Ablebits Team) says:

November 4, 2020 at 5:11 pm

Hello Rita,

Thank you for your comment. I have just replied to you by email.

Elizabeth A Bethel says:

September 17, 2020 at 2:43 pm

Does this product Combine Duplicate Rows And Sum The Values in multiple rows/columns?
I Want to remove duplicates in column a, and add the cells in b, c, and d.

Alvarado, Alma Corina $73.49 $1,883.65 $1,133.52
Alvarado, Alma Corina $30.00 $1,476.14 $522.15
Alvarado, Alma Corina $88.29 $2,379.86 $4,553.16

Result is one single row with
Alvarado, Alma Corina $191.78 $5739.65 $6208.83

Mary Trifuntova (Ablebits Team) says:

September 17, 2020 at 2:56 pm

Hello Elizabeth,

Thank you for your comment. I've just replied to your email request providing the instructions for the Merge Duplicates tool that will work for your task perfectly. Check out your Inbox. Thank you.

Jason Jones says:

September 9, 2020 at 7:47 pm

IS Ablebits 2018.4.104.7510 add-in compatible for office 365? Are there remediation steps

Katerina Bespalaya (Ablebits Team) says:

September 10, 2020 at 9:03 am

Hello Jason,

Version 2018.4.104.7510 is quite an old one and may not work with the latest Office updates, especially with Office 2019 and Office 365. Besides, we provide support only for the latest version of the add-in since there might be some bugs and technical issues in the previous versions that have already been fixed in the new one (version 2020).

If you purchased a license for our product previously, you can send us your license key to support@ablebits.com and we'll check what version of the add-in it is compatible with. Thank you.

Lauren Jones says:

August 22, 2020 at 11:02 am

My ablebits does not work with my windows 365. It says processing but then freezes. Please assist.

Ekaterina Pechyonkina (Ablebits Team) says:

August 22, 2020 at 11:08 am

Hello Lauren,

Thank you for contacting us. I have just replied to you via email, please check your Inbox and send me your license details. Thank you.

Robin says:

August 9, 2020 at 8:37 pm

I am importing date columns into a sqlite database program via a plugin that works with the program that allows .csv importation. I noticed today that every date I import is one date LATER than the date imported.

The column in the database is formatted as being a date with dd MMM yyyy style the hour, minutes and seconds are in the column but they are witheld from being seen. I set the column in the list to be imported as a date formatted custom dd MMM yyyy.

My question is this,

Since it seems that nothing I can do will allow that list to import the days accurately, and I know that it will show them as being one date later, is there a function in the Ablebits Excel Suite that will allow me to simply format the date column to show them as one day later so that the imported list will end up being the true date in the field?

Sorry for such a long set up, but the extra information may lead to answering the question in a fundamental way rather than just asking if the plugins will automatically format date columns by one day. I don't know how to use Excel formatting beyond the very basics.

Aksana Pachkouskaya (Ablebits Team) says:

August 10, 2020 at 10:49 am

Hello Robin,

Thank you for your question. We have just replied to you by email.

Bill Hughes says:

May 26, 2020 at 8:13 pm

HI, I have been using the trial version of the Merge Tables Wizard for Excel for Mac. It has been working well. I now want to buy it so that I can merge tables wth more than 50 rows. I have a couple of questions:
1. I assume this product is included in the Ultimate Suite even though your product information says the Ultimate suite is for a Windows platform?
2. I have an Microsoft 365 subscription on a Macbook Pro. This is the setup where the trial version of the Merge Tables Wizard for Excel for Mac worked. I want to confirm that the Merge Tables Wizard included in the Ultimate Suite will work with Microsoft 365 Excel (for Mac).
3. Will all of the Excel add-ins in the Ultimate suite work in Microsoft 365 Excel (for Mac)?

Mary Trifuntova (Ablebits Team) says:

May 27, 2020 at 6:53 am

Hello Bill,

Thank you for your comment. You see, we used to have Merge Tables Wizard for Mac, but we no longer sell and support it. This feature is available as a part of our Ultimate Suite for Microsoft Excel that works for Windows only.

However, you can have a look at Merge Sheets add-on for Google Sheets that has similar functionality and can be run in a browser on your Mac. The add-on is installed and purchased directly through G Suite Marketplace, feel free to test it out for 30 days for free to see if it suits your needs.

Jonathan says:

March 3, 2020 at 5:49 pm

When using the Add Text feature, what condition(s) would be preventing me from typing text into the field? I'm unable to add the text that I would like to append or prepend to the selected range.

Thanks!

Katerina Bespalaya (Ablebits Team) says:

March 3, 2020 at 6:55 pm

Hello Jonathan,

If you refer to the Add Text feature in our Ultimate Suite for Excel, please make sure that you're using the latest version of the add-in. Feel free to download it from this web-page and check it out. If you are still having difficulties, please contact us at support@ablebits.com for further assistance.

Judith Omondi says:

February 18, 2020 at 5:55 am

Hi
We are running an application dependent on ablebits which was working on office 2016. we upgraded to Office 365 Proplus, now the application is not running, missing .ocx files error "component MScomctl.ocx" is missing or its dependencies.

How can we resolve this? is ablebits supported in O365 proplus?

kindly assist.

Katerina Bespalaya (Ablebits Team) says:

February 18, 2020 at 10:56 am

Hi Judith,

Sorry to hear that you are having difficulties with our product. For us to be able to help you better, please let us know what Ablebits add-in you're trying to use in your Office 365 ProPlus. If you have bought a license for the product previously, please also send us your current license key to support@ablebits.com. We'll check in our records what version your license is compatible with and if it supports your Office version. Thank you.

Patrick says:

January 28, 2020 at 6:27 am

Hi, does your product work with Excel 2016 for Mac?

Ekaterina Pechyonkina (Ablebits Team) says:

January 28, 2020 at 9:45 am

Hi Patrick,

Thank you for contacting us. Our add-ins are designed for Windows only and don't work on Mac.

Joseph Morrison says:

August 19, 2019 at 1:53 pm

Hello,
I have a user with Ablebits add-in installed on Excel 365 Pro Plus. We are at version 1902, 64-bit architecture. The add-in is loading, but the icons are all blank in the ribbon, like it's not compatible. Is there something that we can do to help this user?

Thanks,
Joe

Mary Trifuntova (Ablebits Team) says:

August 19, 2019 at 3:43 pm

Hello Joe,
Thank you for contacting us.

We have just replied to you via an email. Please try the solution we recommended and let us know about the result. Thank you.

Marco C says:

July 24, 2019 at 10:33 am

hello, I installed the additional Phrase Template component on the desktop version of Outlook 365 with Win10 but my models are not saved. I create a new model, I try it, but at the next mail I get only your default models. I tried to delete them all but then reappear. My collaborators, who use the same software and the same operating system do not encounter the problem; everything works correctly. What can it depend on? Thanks for an answer.

Mary Trifuntova (Ablebits Team) says:

July 24, 2019 at 3:00 pm

Hello Marco,
Thank you for contacting us.

We have just replied to you via an email. Please provide us with the requested information and we’ll do our best to help. Thank you.

Tafadzwa Murinda says:

June 24, 2019 at 11:26 am

Hi, I am using office 365 proplus and I have installed ablebits , its not working on excel. It appears but it doesn't respond when clicked. it is supported

Mary Trifuntova (Ablebits Team) says:

June 24, 2019 at 11:40 am

Hello Tafadzwa,
Thank you for contacting us.

We have just replied to you via email, please check your Spam/Junk/Trash email folders if you still don’t see our email in your Inbox.

Dorian says:

April 10, 2019 at 11:45 am

hi there

i've installed ablebits on a new win10-device with outlook, can see the addin in outlook, manage the templates, but when i open a new mail, there are no template phrases to choose from, as i know it from other installations.

is it maybe hidden and has to be activated oder is this maybe a bug?

thanks in advance for your help
dorian

Mary Trifuntova (Ablebits Team) says:

April 10, 2019 at 12:30 pm

Hi Dorian,
Thank you for contacting us.

Our support team specialist has just replied to you via email. Please check your Inbox.

Marcello says:

May 21, 2019 at 6:31 am

Hi Mary,
I have the same problem since using Outlook 1904 in Win 10. Template phrases can be used only online not in the desktop-app of Outlook.
Thanks for your support.
Marcello

Mary Trifuntova (Ablebits Team) says:

May 21, 2019 at 10:41 am

Hi Marcello,
Thank you for contacting me.

We have two different Template Phrases - the standard Template Phrases and Template Phrases for Outlook online. The first one works for the desktop version of Outlook, while the second one supports Outlook online as well.

For me to be able to understand the problem better, please tell me which Template Phrases you use.

Thank you.

durga says:

March 9, 2019 at 9:28 am

I'm looking for such a way that, any word documents (Word 2016) containing a particular text i.e. section 2 should be automatically link to bookmark create in master word documents..

Suppose if i download a word file and it contains a text i.e. section 2 and automatically the text "Section 2" should be hyperlink to bookmark

Anyone if knows the solution, pls kindly provide to me...i would be really thankful to him/ her..

Irina Goroshko (Ablebits Team) says:

March 11, 2019 at 8:53 am

Hello Durga,
Thank you for the comments. I am sorry, but we answer only questions related to the Ablebits products.

I wish I could assist you more.

Lowell says:

October 24, 2020 at 6:24 pm

I get a message when trying to merge 2 sheets...it States that the range is to large for the current version to process.. what are the range limits?

Mary Trifuntova (Ablebits Team) says:

October 25, 2020 at 7:57 am

Hello Lowell,

Thank you for contacting us. Sorry to hear you faced difficulties with our add-in. Our add-in does not have clearly defined limitations on the number of rows / columns / sheets with the data to process.
For us to be able to understand the problem better, please send us the following details to support@ablebits.com:

- What is the name and version of our software you use? You can find this information in your Control Panel -> Programs and Features.
- What version of Windows and Office do you use?
- What is the size of the tables you are trying to merge? Hundreds/thousands of rows?

Thank you in advance for your reply.

durga says:

March 9, 2019 at 9:24 am

I'm looking for syntax i.e. in hyperlink forumla suppose " =HYPERLINK("F:\Study Material\Circular Cgst\2018\" & A453 & ".docx",A453),

in above formula the word "Circular Cgst" has to be taken from C2 cell i.e. =HYPERLINK("F:\Study Material\"A2"\2018\" & A2 & ".docx",A2)

I have tried by +A2, "A2" but its not working..

Pls any one can provide the solution..really thankful..

Alberto says:

February 25, 2019 at 11:33 am

Hi,
I would like to know if your suite includes a DatePicker that can be used as ActiveX control into x64 Excel VBA (as the DLL mscomct2.ocx is not anymore supported from Excel 64 bit VBA)

Thanks
Best regards

Alberto

Irina Goroshko (Ablebits Team) says:

February 25, 2019 at 2:33 pm

Hi Alberto,
Thank you for the question.
Unfortunately, our Date Picker can not be used as ActiveX control into x64 Excel VBA.

Thank you.

Supported Windows and Office versions

Add-ins for Microsoft Excel and Outlook

What versions of Microsoft Windows do your add-ins work with?

What versions of Microsoft Excel and Outlook do your add-ins support?

Add-ins for Microsoft Excel

Plug-ins for Microsoft Outlook