Excel Add-in V3.3: Unable to open a workbook that has been created in an older version of the add-in
This item has been identified as an outstanding known issue. A workaround is provided until the issue is officially fixed.
Some users are experiencing an issue where workbooks that have been created in an older version of the Add-in will not open. The workbook will briefly open before Excel will unexpectedly close.
This issue is caused by using an older version of the Add-in after upgrading to a newer one. For example, user A upgrades to V3.2 but user B is still on V3.1 and both users refresh connections in the same workbook.
There are two options that will allow use of the workbook again.
Option 1 (Requires downloading a copy of V3.1 and allows the workbook to be used in V3.3)
Open the affected workbook and refresh all the connections.
From this point onward it is important to only use a single version of the Excel add-in to avoid running into this situation again. For example, make sure that all users on this workbook have updated to V3.3.
Install Excel Add-in V3.3 and open the workbook. It should open successfully.
Refresh the connections to verify that it is working as expected.
Use an older version of the Add-in i.e. the version used prior the upgrading to V3.3
If this workaround is not suitable in your use case, please contact Support at email@example.com.