TABLE OF CONTENTS:

What to do if Excel Connector for JIRA tab is not visible in Excel?

Check if you have installed Visual Studio 2010 Tools for Office Runtime. You can download it from here.

If you still can’t see this tab, click Microsoft Office Button, then Options and Add-ins. In the details pane, check where Excel Connector for JIRA AddIn is located.

If Connector is located in the Disabled Application Add-ins list, in the Manage box select Disabled Add-ins and click Go. Then select Excel Connector and click Enable. After that, you probably should restart Excel.

Otherwise, if Connector is located in Inactive Application Add-ins list, in the Manage box select COM Add-ins and click Go. Then, in dialog box, select Excel Connector check box and click OK. After that, Excel should load add-in without restart.

What to do if I can’t log in Excel Connector, because of AXIS Engine problem?

Check in JIRA Administration Pane if Accept remote API calls is set on ON. This property is located in General Configuration.

How to work with Excel Connector offline on Excel without installed Add-In?

There are possibility to do that, but you must follow the instructions below:

• After generating a sheet, you need to log in to JIRA from Excel, refresh these sheet and then save it (on Excel with installed Add-In).

• All changes made offline, must match the format of the data in sheet (correct field values, values for multi-select fields must be separated by commas, etc.). If you use Excel without installed Add-In, there will be no validation for entered data.

• Before logging to JIRA Excel with installed Add-In, mark issues which will be updated (by changing the background color of the rows corresponding to these issues).

• At the end, when you logging to JIRA from Excel you should deselect "Refresh sheet after logon" option and send changes to JIRA.If all fields are filled with the correct values, there should be no problem with sending changes to JIRA.

How to work with Excel Connector offline on Excel with installed Add-In?

You must follow the instructions below:

• After generating a sheet, you need to log in to JIRA from Excel, refresh these sheet (here you need to be online).

• Then you can provide changes in your sheet (even if your session will be expired). You can’t only edit issue status. That requires to be online.

• After making changes save Excel sheet.

• At the end, when you logging to JIRA from Excel again, you should deselect "Refresh sheet after logon" option and send changes to JIRA.

ERROR: Object reference not set to an instance of an object.

There are some causes of this problem:

• Not generated Excel sheet from JIRA.

• Using unsupported language.

• Opened more than one Excel sheet.

• Generated Excel sheet modified manually.

ERROR: The given key was not present in the dictionary.

There are some causes of this problem:

• Opened more than one Excel sheet.

• Generated Excel sheet modified manually.

• Some fields in Excel sheet have same name.

HRESULT: 0x800A03EC

There are some causes of this problem:

• Not generated Excel sheet from JIRA.

• Using unsupported language.

• Opened more than one Excel sheet.

• Generated Excel sheet modified manually.

What to do if log in window won't appear?

Please check if you generate and open Excel sheet from JIRA before trying to log in.

Why I can't edit some fields?

Unsupported custom fields are blocked and can't be edited. Check if your field is one of them.

ERROR: The request failed with HTTP status 503: Service Unavailable.

Check in JIRA Administration Pane if Accept remote API calls is set on ON. This property is located in General Configuration.