Troubleshoot and find solutions to known errors in XLTools

Quick repair tool

If you get errors when you install, reinstall, uninstall, install updates, or when XLTools tab keeps disappearing in Excel – try this Repair Tool.


Download the Repair Tool

Click the link above Save the file Find ‘XLTools.Repair.exe’ in your downloads folder Right-click and run as administrator Choose XLTools version, e.g. the current version Click the button “Repair and install” Click Yes, if prompted to install the necessary Microsoft components Wait for the repairs to complete Done, the latest XLTools version is installed Open Excel, XLTools tab should be there.

Downloads and installation

Licenses and purchasing

Features and ribbon

Any questions or suggestions?
HhHello. Same issues as previous comments: even with repair, I don't find the option Add in the Excel options. Any help please?
September 7, 2021 at 08:30
Mark ProctorI have purchased the Calendar Toolkit but have the following problems. 1) After embedding into an xlsm it does not show on any system (x32/x64) 2) Code inserted into the xlsm is not Option Explicit compliant 3) Also is it possible to call the Calendar to show via VBA? 4) Can the calendar be shown on a UserForm?
July 15, 2021 at 02:14
Karu DonaldsonHow can we customize the add-in deployment to allow us to pre-configure 1. enable version control 2. set remote repositories eg github.com/org_name/repo1 based on string or filename perhaps? 3. Set the VCS function to auto push to a remote repository after a commit is made? If we have to configure the repo manually that's not really an issue but it would be nice if there were some XML type configuration we could customize? Also, it was noted that the git repository that is auto created, adds a subdirectory which becomes the new repository. Is there a way we can automate the "remote repository" on enabling VCS in the add-in or does this all have to be done manually at this point? Thanks
March 17, 2021 at 21:20
HugoHow can I "remove" "uninstall" XLTOOLS from my excel?
December 14, 2020 at 09:54
Sulthan IbrahimI am regular client. I have paid for renewal of xl tool. But in this time, error message came that excel detected without service pack. Therefore I have installed MS Office 2007 with service pack. Even though another message that macro to be enabled. But In My Excel, already macro has been enabled. Pls let me know what to do
December 9, 2020 at 13:52
garyI cannot get the XL tab to display. The following directions from the FAQ did not work, even after following them and restarting: "Open Excel > File > Options > Add-Ins > Select ‘Manage ‘Com Add-Ins’ on the bottom of the box > Go > Check the box ‘XLTools Add-in for Microsoft Excel’ > Ok. When I follow the directions, no option for "Check the box ‘XLTools Add-in for Microsoft Excel’" apppears. Also, there is no XLTools tab under customize ribbon. I tried the repair tool and it did not help. Thank you. gary.
August 21, 2020 at 23:21
Qin LiuI have installed the XLTools, but there is no XLTools tab in my excel worksheet. I have checked the option page, there is no XLTools add-in in the Com Add-Ins
August 17, 2020 at 22:37
AhmedHi, I have two questions. 1) "Execute Command" under XLTools > Automation is disabled. How to enable "Execute Command"? 2) Where to find "XLTools.SQLSelect command" in XLTools? XLTools version: 5.1.3.1921 Thanks, Ahmed
February 2, 2020 at 21:46
Maria BalobanovaHello Ahmed, Please take a look at the Automation feature guide. There you will find a tutorial file that explains how to create commands (including XLTools.SQLSelect). Once you've created the automation command in a table, select the range of the command - and the "Execute Command" button will become available.
February 3, 2020 at 09:30
AhmedThank you, Maria for your quick response. How to automate run SQL to get data (with XLTools.SQLSelect) and export it to csv file (XLTools.ExportToCSV) in one step on custom button? Do you have manual to check available options, parameters for using sql and exporting data to csv. Thanks Ahmed
February 8, 2020 at 21:20
Maria BalobanovaHi again, I have emailed you an example file. To summarize, here's what you can do: 1) Create XLTools.SQLSelect command. 2) Create XLTools.ExportToCSV command right below it. 3) Select the entire range of both commands and assign a single button. The tutorial here has examples and available parameters for automation commands. We are working on a more detailed guide.
February 11, 2020 at 10:37
AhmedThank you, Maria. Both solutions are working perfectly. I have few more questions: 1 - Is there any option to "execute command button" without opening excel or command line execution in windows? That will be the perfect solution for most of small scale data integration programs. 2 - Do you have example for export data to cloud based MySQL with "XLTools.ExportToMySQL"? 3 - Looking for examples for "XLTools.ApplyTemplate", "XLTools.ImportFromSendGrid" and XLTools.SaveSheetsAsFiles? Thanks in advance. Ahmed.
February 17, 2020 at 02:15
Maria BalobanovaHi Ahmed, 1. - no, at the moment there is now way to "execute commands" button without opening Excel. That's a good idea for future releases, thank you! 2. - here is an example of the “XLTools.ExportToMySQL” command. 3. - we have some examples here, and I have sent you an email with a sample file.
February 17, 2020 at 13:09
Jill FitzsimmonsGood Evening, I am trying at present to test this add in on the free trial before possibly extending to certain employees. When I enable the version contract and commit changes for a 2nd time, the error box is appearing with the following: An unknown error occurred: The directory is not empty. Could you advise what this is in relation too and also a way that committing changes can be done on more than one occasion to allow the show change log to work to monitor and maintain protection on updating spreadsheets.
August 20, 2019 at 22:05
Maria BalobanovaHello Jill, thank you for reporting the issue. Our developers will need some more details, I have sent you an email.
August 21, 2019 at 09:27
Raja osama I am unable to connect to tally by any mean, even my tally is on port 9005 enabled which can be accessed by browser, i just bought the software was working on trail versions but since i bought the app i am unable to make it work. Can you please help
July 28, 2019 at 14:04
Maria BalobanovaHi Raja, seems that we have a misunderstanding. Looks like you are looking for some product - Excel to Tally? Our Excel add-in XLTools does not include features for Tally. I have sent you an email with details.
July 29, 2019 at 08:57
Ilkka Ristiluoma I have similar problem like this: I cannot get the XL tab to display. The following directions from the FAQ did not work, even after following them and restarting: "Open Excel > File > Options > Add-Ins > Select ‘Manage ‘Com Add-Ins’ on the bottom of the box > Go > Check the box ‘XLTools Add-in for Microsoft Excel’ > Ok. When I follow the directions, no option for "Check the box ‘XLTools Add-in for Microsoft Excel’" apppears.
May 29, 2019 at 13:59
Maria BalobanovaHello Ilkka, Thank you for reporting this. Looks like there were some errors during installation. Please reinstall XLTools. I have emailed you the details.
May 30, 2019 at 08:45
Loree JacobekI'm having the same problem as above. Can you help?
December 10, 2019 at 20:02
Maria BalobanovaLoree, thank you for reporting this! Sometimes Excel disables add-ins for no apparent reason. We have sent you an email with a suggestion how to fix this.
December 12, 2019 at 10:12
Elliott Flood I cannot get the XL tab to display. The following directions from the FAQ did not work, even after following them and restarting: "Open Excel > File > Options > Add-Ins > Select ‘Manage ‘Com Add-Ins’ on the bottom of the box > Go > Check the box ‘XLTools Add-in for Microsoft Excel’ > Ok. When I follow the directions, no option for "Check the box ‘XLTools Add-in for Microsoft Excel’" apppears.
April 14, 2019 at 18:17
Maria BalobanovaHello Elliott, thank you for reporting this. We need some details to figure out what's causing the error (your Windows version, Excel version, etc.) I have sent you an email with details.
April 15, 2019 at 09:32
Jaroslaw Hi, I try to commit file that is held in local network folder and I get this error: "An unknown error occured: Failed to rename lockfile to...". This doesn't happen with the copy of this file on my local drive. How should I proceed?
January 10, 2019 at 13:17
Maria Balobanova

Hi Jaroslaw,

Are you referring to the Version Control feature? We'll need to take a closer look. I have sent you an email.

January 10, 2019 at 13:43
JeremyHi, I'm getting this error when trying to run a query: Execution Failed Unable to find an entry point named 'sqlite3_config' in DLL 'SQLite.Interop.dll'. Note: I've downloaded SQLite & confirmed the dll file - however I can't access it to confirm the config file. Please advise on how I can resolve this
October 12, 2018 at 17:44
Maria BalobanovaHi Jeremy, I assume you refer to our SQL Queries add-in. It does use SQLite language, but you do not have to install it (it's already configured in XLTools). However, it sounds like you want to connect to your SQL database and use XLTools to run queries on that data. Is this the case? Then sorry, the add-in works a bit different. XLTools SQL Queries add-in is meant to run queries in Excel and directly against data in your Excel tables. Hope you will find it useful for your tasks as well!
October 12, 2018 at 18:35
Jim ManzI installed XLTools on a computer where the logged in user does not have admin rights (had to provide an admin user password) and the XLTools plugin is nowhere to be found in Excel. It's not only not visible but also is not found under COM Add-in's in the manual enabling step. Does it have something to do with installing with a different user? Thanks, Jim
May 23, 2018 at 12:43
Maria BalobanovaHi Jim, like most add-ins of this type, XLTools requires administrator rights for installation. If you have several users on the same computer, XLTools should be installed for each of them separately.
May 24, 2018 at 09:45
Peter Cook Hi, I'm having an error when trying to 'commit changes' through 'version control' as per the following: "An unknown error occurred: Illegal charachters in path."  The file name is relatively clean with only letters and numbers, and have tried alternating spaces with '_'. File is ~20mb with multiple links, queries and connections. Please help Cheers, Peter
March 29, 2018 at 03:18
Maria Balobanova

Hi Peter,

We'll need some more details to find out what's causing the error. I have sent you an email.

April 2, 2018 at 11:10
Mik Carbajales-Dale Hi there, When I try to install inside Excel for Mac 2016 I get this error.
March 20, 2018 at 21:35
Maria Balobanova

Hello Mik,

We do not have XLTools desktop version for Mac. It is only compatible with Windows. But you may find some of our online apps useful.

March 21, 2018 at 10:31
Joan I install xltool.net calendar but face problems to upload it. The message that appears says that the app is not configurated correctly. Could anyone help me on that?
February 23, 2018 at 08:13
Maria Balobanova

Hi Joan, sorry to heat that! These online apps are developed on MS Add-in Developer Platform, which Microsoft seems to be actively upgrading at the moment. So some performance inconsistency is to be expected. But there is nothing much we can do from our side right now.

You are welcome to download our desktop add-in. It also has the Popup Calendar and much wider functionality.

February 26, 2018 at 09:13
simon After i installed XLTOOLS and when i open it the spreadsheet doesnt open up. its just blank.
February 12, 2018 at 10:02
Maria BalobanovaHi Simon, do you mean you can't find XLTools tab? In this case please activate manually: Excel > File > Options > Add-Ins > Select ‘Manage ‘Com Add-Ins’ on the bottom of the box > Go > Check the box ‘XLTools Add-in for Microsoft Excel’ > Ok. If this doesn't help, try reinstalling XLTools add-in.
February 13, 2018 at 08:51
brian I just installed pop up calendar addin for excel pro 16, the xltool tab doesn't automatically open when i start a new workbook. I have to go to  Options > Add-Ins > Select ‘Manage ‘Com Add-Ins’ and enable the add-in everytime i open a new workbook. When i save a workbook that i have used the above process to enable XLtools, and reopen it, i have to go through the whole process again. Help please
November 27, 2017 at 16:04
Maria Balobanova

Hi Brian, looks like the add-in did not install properly. Please uninstall XLTools, download again and follow the setup wizard. Hope it helps! Otherwise, we'll try to find a different solution.

November 28, 2017 at 14:49
LauraIn the old free version of XLTools I was able to select Data Cleaning, click the 'select all data' button (between column A and Row 1) and then just hit Apply and my data would be cleaned. What is the best way to quickly select all data to be cleaned since this way no longer seems to work?  I have Essentials 5.0.0.764
October 27, 2017 at 17:42
Maria Balobanova

Hi Laura, thank you for reporting this! Indeed, after the recent update automatic range selection in the Data Cleaning tool does not work properly. We will try to fix it asap. In the meanwhile try selecting the table the usual way - select any cell in a table > Ctrl+A to select the range > apply Data Cleaning tool.

October 30, 2017 at 10:11
RajeevHi After installation of XLTOOLS add ins whenever I go for a print "Accessing Printer" pop up comes in which could last for sometime, sometimes I feel that the system has hanged. Kindly advice. Thanks & regards
August 17, 2017 at 01:53
Maria BalobanovaHi Rajeev, thank you for reporting this! It is the first report of this kind. We'll need more information to figure out what the problem is. I have emailed you the details.
August 17, 2017 at 11:34
Dmytro NeschetnyiHi! I have a license for calendar, but calendar icon not active in excel after product activation
July 7, 2017 at 10:40
Maria BalobanovaHi Dmytro, looks like you are running an outdated XLTools version. I have emailed you the details about the upgrade.
July 10, 2017 at 09:25
Dan HHi, When trying to commit changes made to our worksheet, the following error is presented: "An unknown error occurred: Out of present range. (Exception from HRESULT: 0x8002000A (DISP_E_OVERFLOW))" No new log entry is added to the Versions History, but a copy of the worksheet can be found in the revisions folder. This happens when running 32-bit Excel 2013 on Windows 7. The workbook is fairly large (~30 mb). XLTools works just fine on a new, empty workbook. Any idea what might be causing this? Any help appreciated! Dan
July 6, 2017 at 13:55
Maria BalobanovaHello Dan, Thank you for reporting this! We will need to take a look at the file.
July 6, 2017 at 14:37
RiyasI have installed XLtool UnPivot Ad in . But all tool seems Disabled. Can you please suggest me how to Activate it
February 5, 2017 at 08:04
Maria BalobanovaHello Riyas, The Free Trial should start automatically. If it did not happen, please open XLTools tab > Click the License button > Click the Free Trial button. This should enable all functionality, including the Unpivot table. Activating a trial requires Internet connection, though. So I have emailed you the free trial license key just in case. Hope you'll find XLTools useful for your tasks!
February 6, 2017 at 10:52
Baiju AnthonyHi, I am interested in this MS Excel addon xltools for running sql queries. I have downloaded and started the installation, The installation went smooth for most of the time. . At last it gave me following error. I checked the install.log file, here are the last few lines ...please help. I am running the xltools setup as a administrator. ---------------------------------------------- URLDownloadToCacheFile failed with HRESULT '-2146697208' Error: An error occurred trying to download 'https://xltools.net/clickonce/pro/en/XLTools.vsto'. Status of package 'Microsoft Visual Studio 2010 Tools for Office Runtime (x86 and x64)' after install is 'InstallSucceeded' -----------------------------------------
January 29, 2017 at 15:19
Maria BalobanovaHi Baiju, Seems that your browser security settings are blocking XLTools from proper installation. Please try the following: 1. Temporarily block browser security settings: Clear security options temporarily or add an exception: Internet Explorer > Tools > Internet options > Security tab > Trusted sites icon > Sites button > paste "https://xltools.net/" > Add. Internet Explorer > Tools > Internet options > Advanced tab > Clear Warn in changing between secure and non secure mode > Then reboot your PC. 2. Install XLTools again: Open Internet Explorer > Click Ctrl + F5 (this should clear cache in your browser) > Download XLTools > Save file > open This PC\Downloads > Find the ‘XLTools.exe’ file you have just saved > right-click and ‘Run as administrator’. > After installation bring the security settings back. Please let me know how it goes!
January 30, 2017 at 11:21