Problem with first installation
After installing the Excel to Jira Integration Add-In, the JIRA tab does not show up.
Solution A
The most likely reason for that is a missing dependency to a required runtime library. Follow these steps to install the missing dependency:
Download installer from the here: Download Visual Studio 2010 Tools for Office Runtime from Official Microsoft Download Center.
Follow the steps in the installation wizard.
Uninstall the Excel Add-in in Programs and Features.
Install the Excel Add-in following the steps described here.
Solution B
Applies to Versions before 4.1. We suggest to install latest version.
Installing a 32Bit AddIn into a 64Bit Office and vice versa will not work. This is independent of your Windows version, i.e. a 32Bit Windows can only run 32Bit Office, but a 64Bit Windows can run 32Bit Office or 64Bit Office. Follow these steps to identify your Office version:
Open Excel and create a new empty file.
Click "File" and "Account".
Click "Info on Excel" and check the first line.
If it reads something like "Microsoft Excel 2016.... 32 Bit" you are running a 32bit Office.
If it reads something like "Microsoft Excel 2016.... 64 Bit" you are running a 64bit Office.
Close Excel and uninstall the Excel to Jira Integration Add-In.
Download the correct (latest) version of Excel to Jira Integration Add-In and install it.
Problem after re-installation
After re-installing the Excel to Jira Integration Add-In, the JIRA tab does not show up any more.
Solution A
The reason for that is that the COM Add-in is disabled. Follow these steps to enable the plugin again:
Within Excel navigate to File > Options.
Select tab Add-ins.
Select at Manage drop down list: COM Add-ins, press Go..
Enable checkbox at Excel to Jira Integration.
Press OK.
Solution B
When the plugin is removed from the list of com add-ins inside Excel options, the next time that is installed, it would not shown in the Ribbon.
To solve this problem is necessary to search and remove the register keys called R4JExcel, through of RegEdit tool of Windows. In both HKEY_LOCAL_MACHINE or HKEY_LOCAL_MACHINE.
For example, would delete manually:
Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel\AddInLoadTimes (Delete entry named R4JExcel)
Computer\HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\AddinsData\R4JExcel
Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel\Addins\R4JExcel
Example:
Once the Keys are deleted, in a new installation the Jira option will be in the Ribbon again.
Note: User has to have special care to only delete registers related with R4JExcel registry entries.