Issue Summary

Given two excel worksheets, where one of them has one or more cells linked to cells from the other worksheet. The links between the two cells do not get updated when accessed.

This is because when a worksheet is linked to another, the path to that other excel worksheet is recorded and when this file is uploaded to Confluence and accessed via the Companion App, this path remains and does not get updated. This causes errors, where the worksheet will be looking for linked worksheet via the path defined in the cell. The following error can be seen:

Some links in your workbook can not be updated at this time 

Steps to Reproduce

1. Create two Excel worksheets.
2. Link one worksheet to another. 
   1. The following tutorial explains how to do this: https://www.youtube.com/watch?v=_YgCJb2FF-4
3. Upload both Excel Sheets to Confluence. 
4. Open the linked Excel worksheet via the Companion App, this will open the worksheet.
5. Select the the cell(s) that where the link to the other worksheet was defined. 
6. Notice that the path to the other worksheet (in the user's machine)remains the same. 
   1. This presents an issue when multiple users who are using different machines are editing the same excel sheet, as Excel will be looking for the linked sheet in the defined path

Expected Results

The path needs to be updated, or there should be a mechanism to find out where the linked worksheet is and update the path accordingly. 

Actual Results

The path to the other file does not change 

 
='/Users/xxx/Downloads/excel/[Document1.xlsx]Sheet1'!D3

Also, please note that if the linking between excel sheets happen while using the Companion App, the following type of paths might be seen as well

='/Users/xxxx/.atlassian-companion/e1076d92-ea04-4479-8d6e-3a15555f574b/[Document1.xlsx]Sheet1'!$D$3

The difference between both types, is that the earlier one the linkage between the excel sheets happen before the files were uploaded to Confluence. While the second one happens when the process of linking one document to another happens while using the Companion App

Workaround

there is no known workaround at the moment.