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)
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..
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?
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?
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
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
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.
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?
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?
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.
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.
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.
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)?
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.
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.
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.
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
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.
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.
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.
Responses
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
Hi Alberto,
Thank you for the question.
Unfortunately, our Date Picker can not be used as ActiveX control into x64 Excel VBA.
Thank you.
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..
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..
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.
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?
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.
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
Hi Dorian,
Thank you for contacting us.
Our support team specialist has just replied to you via email. Please check your Inbox.
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
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.
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
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.
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.
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.
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
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.
Hi, does your product work with Excel 2016 for Mac?
Hi Patrick,
Thank you for contacting us. Our add-ins are designed for Windows only and don't work on Mac.
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.
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.
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!
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.
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)?
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.
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.
Hello Robin,
Thank you for your question. We have just replied to you by email.
My ablebits does not work with my windows 365. It says processing but then freezes. Please assist.
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.
IS Ablebits 2018.4.104.7510 add-in compatible for office 365? Are there remediation steps
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.
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
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.
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.
Hello Rita,
Thank you for your comment. I have just replied to you by email.