If following an upgrade of AOI you are prompted to upgrade when you try to open your Journal Upload sheets in Excel but get one of the errors below:
Unexpected error (Exception from HRESULT: 0x800401A8) during workbook upgrade activity.
Unexpected error (Exception from HRESULT: 0x800401A8) during NL worksheet create.
Then please see the following, as newer versions of Access Office Integration (AOI) have built in upload templates designed to replace the old Standalone ones. These can be accessed as follows:
In Excel, select the ACCESS option from the ribbon.
In the ribbon, click on the text Select Upload Template from the Create Sheet dropdown menu.
Choose the required upload template and populate with the required information.
Once set up, the excel workbook can be saved for later use just as the old standalone versions could.