Refreshing whole sheet

If you want to discard changes on your sheet or update issues that are present on it you can use Refresh Sheet button (1).

After pressing it you will be presented with "Refresh Issue" prompt that makes sure, you clicked on Refresh Sheet button intentionally, and inform you about possible lose of made changes (3).

Confirming refresh, will remove any changes you made to issues, query Jira for updates made to them and insert them into your worksheet and remove all new issues you were about to create. 

Open

 To go directly to particular issue in Jira, click on its issue key (highlighted in blue hyperlink from "Key" column). 

Refreshing selected issue(s) only

If you want to get updates from only of some of the issues (while preserving the changes made to the rest of them), select issues you want to refresh and click Refresh Selected Issues button (2). Just like when refreshing the whole sheet, this will discard all changes made to the selected issues in Excel and update them with the latest changes from Jira.

Refreshing single issue from selected issue tab

After clicking a particular issue (1) that is present in a row, user is to be taken to a Tab view that is dedicated only for that particular issue (2):

Open

Anything that is to be changed here, is to be applied only for an entitled in the tab issue. Other issues won't be affected when user decides to use "Refresh issue" button (3).

 Note that the button uses single form ("issue") to underline that only one, selected, is to be affected by modifications of its content.