Answers to frequently asked questions
Where can I get the latest versions of your add-ins?
You can download the latest versions of all our add-ins from the Download section .
What versions of Microsoft Windows do your add-ins work with
All our add-ins support:
Microsoft Windows 7 (32-bit and 64-bit)
Microsoft Windows Server 2008 R2 (32-bit and 64-bit)
Microsoft Windows Vista (32-bit and 64-bit)
Microsoft Windows 2003
Microsoft Windows XP
Microsoft Windows 2000
Note Add-ins for Outlook Express don't work with 64-bit Windows versions.
What versions of Microsoft Excel, Outlook, Outlook Express and Word do your add-ins work with?
Add-ins for Microsoft Excel
Most of the add-ins work with Microsoft Excel 2010 (32-bit and 64-bit), 2007, 2003, XP (2002), 2000 SP3 .
Style Manager and AutoFormat for PivotTables add-ins do not work with Excel 2010 64-bit.
Color Manager, Pivot Table Helper and Cells Assistant add-ins do not work with Excel 2007 and Excel 2010.
Plug-ins for Microsoft Outlook
All add-ins work with Microsoft Outlook 2010 (32-bit), 2007, 2003, XP (2002), 2000 SP3 .
Add-ons for Outlook Express
All add-ins work with Outlook Express 6.x and Windows Mail.
Please note! Windows Live Mail is not supported.
Add-ons for Microsoft Word
All add-ins work with Microsoft Word 2003, XP (2002), 2000 SP3 .
Do you have versions for Macintosh?
Sorry, we don't. Our add-ins are not compatible with Office for Mac.
How do I install the add-in?
Close all Microsoft Excel (Outlook, Word) windows.
Run the setup file and follow the setup wizard.
Restart Excel (Outlook, Word) to see the add-in running.
For silent installation, please use /verysilent key. You go to Start - > Run, enter the path to the setup file and /verysilent key, e.g. C:\Downloads\setup.exe /verysilent
Please note that the add-in is installed only for the current user account , not for all users of the system.
Installation for a restricted user.
You can install the add-in into any folder except for "Program files " having Restricted / Normal user rights. To install the add-in into Program Files (default folder), the administrator or power user privileges are required because this folder is locked for editing by normal user.
If you are a system administrator or an IT person and need to install the add-in for a normal / restricted user, make the user temporarily a power user, install the add-in and return the restricted user rights.
Please do not use the "run as administrator " command, because it will install the add-in for the admin account, not for the current user.
Once installed, the add-in can be run and used by a normal / restricted user, the admin or power user privileges are not required.
How do I uninstall the add-in correctly?
Close Microsoft Excel (Outlook, Word).
Go to Start->Control Panel .
Click on the "Add or Remove programs " icon.
Find and select the add-in from the "Installed Programs " list.
Click the "Change/Remove " button.
Follow the instructions of the uninstall wizard.
Where can I find the add-in after I install it?
Add-ins for Microsoft Excel:
Excel 2010, 2007: If installation is successful, you will see a new Ribbon tab named "Ablebits.com " that contains the add-in icon
Excel 2003-2000: you will see a new toolbar with the add-in icon in your Excel:
Duplicate Remover for Excel
Merge Tables for Excel
Random Generator
Merge Cells Wizard
Advanced Find & Replace
Fuzzy Duplicate Finder
Workbook Manager for Excel
AutoFormat for PivotTables
Style Manager for Excel
Color Manager for Excel
If the toolbar with the add-in icon does not show up, please go to Excel menu -> Views -> Toolbars and check "Ablebits.com ".
Add-ins for Microsoft Outlook:
To find the Auto BCC for Outlook add-in, go to Outlook menu -> Tools -> Auto BCC for Outlook .
To find the Attachments Alarm for Outlook add-in, go to Outlook menu -> Tools -> Attachments Alarm for Outlook .
Excel 2007, 2010: I cannot find the add-in icon / the add-in doesn't work
1. Make sure the add-in loads correctly:
Click the Microsoft Office button in Excel 2007 or Files tab in Excel 2010.
Go to Excel Options->Add-ins .
Select "COM add-ins " from the "Manage " drop-down list at the bottom of the window and click Go.
Find the add-in in the list.
If it is unchecked , check it and close the "COM Add-ins" dialog.
If it is checked , uncheck it and close the dialog. Then open the dialog again and check the add-in item. The icon should appear.
2. Make sure the add-in isn't disabled
Click the Microsoft Office button in Excel 2007 or Files tab in Excel 2010.
Go to Excel Options->Add-ins .
Select "Disabled Items " from the "Manage " drop-down list at the bottom of the window and click Go.
If the add-in is in the list, select the add-in and click the 'Enable ' button, then follow the instructions from step 1 above .
Excel 2003 - 2000: I cannot find the add-in icon / the add-in doesn't work
1. Make sure the add-in loads correctly:
Go to Excel Menu -> Tools -> COM Add-ins... .
Find the add-in in the "COM add-ins " list: If it is unchecked , check it and close the "COM Add-ins" dialog.
If it is checked , uncheck it and close the dialog. Then open the dialog again and check the add-in item. The icon should appear.
If you don't see the "COM Add-ins" menu item:
Go to Excel menu -> Tools -> Customize ...
In the "Customize " dialog box, select the "Commands " tab.
Click on the "Tools " entry in the "Categories " column, and then find the "COM Add-ins " menu item in the "Commands " column. Click and drag the "COM Add-ins " menu item to the Excel Tools menu.
Close all dialog boxes.
2 Make sure the add-in isn't disabled:
Go to the Excel Menu -> Help -> About -> Disabled Items .
If the add-in is in the list, select the add-in and click the "Enable " button, then follow the instructions from step 1 above .
Outlook 2007, 2010: I cannot find the add-in icon / the add-in doesn't work
1. Make sure the add-in loads correctly:
Go to Outlook Menu -> Tools -> Trust Center in Outlook 2007 or Files tab -> Outlook options in Outlook 2010.
Select the "Add-ins " tab.
Select "COM add-ins " from the "Manage " drop-down list at the bottom of the window and click Go.
Find the add-in in the list.
If it is unchecked , check it and close the "COM Add-ins" dialog.
If it is checked , uncheck it and close the dialog. Then open the dialog again and check the add-in item. The icon should appear.
2. Make sure the add-in isn't disabled
Go to the Outlook Menu -> Help -> Disabled Items .
If the add-in is in the list, select the add-in and click the "Enable " button, then follow the instructions from step 1 above .
Outlook 2003 - 2000: I cannot find the add-in icon / the add-in doesn't work
1. Make sure the add-in loads correctly:
Go to Outlook Menu -> Tools -> Options .
In the "Options " dialog box, click on the "Other " tab then click the "Advanced options... " button.
In the "Advanced " options dialog box, click on the "COM Add-ins " button for the "COM add-ins " dialog box to appear.
Find the add-in in the "COM add-ins " list:
If it is unchecked , check it and close the "COM Add-ins" dialog.
If it is checked , uncheck it and close the dialog. Then open the dialog again and check the add-in item. The icon should appear.
2 Make sure the add-in isn't disabled:
Go to the Outlook Menu -> Help -> About -> Disabled Items .
If the add-in is in the list, select the add-in and click the "Enable " button, then follow the instructions from step 1 above .
How to fix OLE Error 800A03EC
This error may occur if you work in Excel 2007 or Excel 2007 2010 and one of your workbooks was created in Excel 2003 or lower. If this is the case, then please use the Excel Convert function:
Open an Excel 2003 or lower workbook in your Excel 2007/2010.
Click on the Office button, select Convert.
Excel will suggest you closing and reopening the worksheet. Click Yes.
After that you can run the add-in without any issues.
How to stop sharing an Excel workbook
To avoid data loss, please make sure all users saved and closed the shared workbook. If you want to keep "Change history", please copy or print out "History Worksheet" before following the steps below.
If you have Excel version up to 2003:
Go to Tools menu, select "Share Workbook " and go to "Editing " tab.
Make sure that you are the only person listed in the Who has this workbook open now box.
Clear the "Allow changes by more than one user at the same time " check box, click OK.
For more details please visit:http://office.microsoft.com/en-in/excel-help/stop-sharing-a-workbook-HP005202023.aspx
If you have Excel 2007:
Open the shared workbook and go to Review tab, click "Share Workbook " in the Changes group.
On the Editing tab, make sure that you are the only person listed in the Who has this workbook open now list.
Clear the "Allow changes by more than one user at the same time. This also allows workbook merging " check box, click OK.
For more details please visit:http://office.microsoft.com/en-us/excel-help/use-a-shared-workbook-to-collaborate-HP010096833.aspx
If you have Excel 2010:
Click Shared Lists on the File menu, select the Editing tab, and clear the Allow Multi-User Editing check box.
For more details please visit:http://office.microsoft.com/en-us/excel-help/use-a-shared-workbook-to-collaborate-HP010096833.aspx
How can I recover my lost license key?
Please use the Product Key Reminder .
How do I activate my license?
Please see detailed instructions in "How to activate your license " section.
Please enable JavaScript in your browser for the Feedback Form to work.
