If you face any troubles when using, installing, activating Ultimate Suite for Excel, find the solution on this page. In case your issue is not listed or the guides don't help - we are always there to support you and answer all your questions: support@ablebits.com
There are no Ablebits tabs in Excel
The add-in cannot load one of its dlls
Excel crashes: Reasons and solutions
Ablebits tabs are in the ribbon, but when you click on them — nothing happens
Ultimate Suite for Excel doesn't show up in Office 365 installed from Microsoft Store
There are no icons under the Ablebits tabs
Microsoft Office related problems while using the add-in
Unable to start the 'AblebitsMakeDiffs.exe' application while using Compare Sheets
The add-in cannot load one of its dlls
Unable to repair or uninstall the add-in
Configure AppLocker to let Ablebits add-ins start
Microsoft Office related problems while installing the add-in
You haven't received your license key
After reinstallation, your license key has stopped working
How to recover your lost license key
Where to find the license key in Excel if the add-in is already registered
Use .NET Framework Repair Tool
Disable Preview Pane in File Explorer
Detect the full version number and bit version of Microsoft Office
Install Desktop Office instead of Office from Microsoft Store
Responses
Hello I am using MacBook Pro and Excel for Mac with 365 subscription. Can I use Ultimate Suit for Excel?
Hello,
Sorry, Ultimate Suite is designed for Windows only and doesn't work on Mac. Please have a look at our Power Tools for Google Sheets as an alternative. The add-on has similar functionality and can be run in a browser on your Mac.
I used VLOOKUPWIZARD to look up email addresses. it appeared to be working, as the desired emails were showing up. but I discovered by accident that the emails displayed were not the email themselves. The actual cell contents were complicated VLOOKUP formulas.
I need to know how to get the actual emails, to drive a mail merge campaign.
Hello Art,
Thank you for contacting us. You see, Vlookup Wizard returns formulas instead of values in case your source data get updated and you need the add-in's results to be refreshed. If however, you need the result to be the value, not formula, use the Covert Values tool next: https://www.ablebits.com/docs/excel-convert-formulas/
If there is anything else we can help you with, please let us know.
Hi - Is it possible to automatically split the names of new rows added to a sheet using the split name tool?
Thanks
John
BTW - I'd also like to automate date calcs for new rows as well. 🙂
Hi John,
Thank you for your question. I'm sorry, but it is technically not possible to have the add-in running in the background and split the newly added names once they are entered. You need to manually start it each time you want to split, calculate, etc.
Good day
I have one sentence (Heading) to be merged across 3 cells but have text as subheaders
in each of the columns, how do I merge only the top heading across without effecting the
others?
Hello Debborah,
Thank you for contacting us.
For us to be able to help you better, please send us a small sample workbook with an example of your headings and the expected result to support@ablebits.com. We'll look into your task and see if our software can help.
Hello,
I am away at the moment, will send as soon as I am back.
Thank you.