Ultimate Suite for Excel: Troubleshooting

If something went wrong while using Ultimate Suite

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

Runtime issues

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

Installation issues

The add-in cannot load one of its dlls

Windows protected your PC

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

Activation issues

You haven't received your license key

Activation limit exceeded

Incorrect 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

Windows and Microsoft Office how-tos

Update your Microsoft Office

Repair your Microsoft Office

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

Take a screenshot to send to our support team

Responses

LEVENT Veryeri says:
April 7, 2020 at 8:01 pm

Hello I am using MacBook Pro and Excel for Mac with 365 subscription. Can I use Ultimate Suit for Excel?

Reply

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.

Reply
Art Atkinson says:
May 19, 2020 at 3:06 am

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.

Reply

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.

Reply
John Batten says:
June 28, 2020 at 8:09 am

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

Reply

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.

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.
60+ professional tools for Excel
60+ professional tools for Excel
2019–2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard