When you integrate AOI with Microsoft Excel, an Access tab and an Access InXL tab appear in the menu bar at the top.
There may be times when these tabs don't appear. To resolve this, follow the sections below.
Note: External factors such as Windows updates or changes to user profiles etc may affect AOI and it may be useful to liaise with your IT provider as well as support.
Microsoft Office version
To ensure AOI runs correctly, we recommend you use the latest version of Microsoft Office. You can check this on their website.
Check you've enabled the add-in and your Trust Center settings
For the tabs to appear in Microsoft Excel, you need to enable the AOI add-in.
Check your licence
In order for the tabs to appear in Microsoft Excel, you need to check that your licence is valid and you haven't reached the maximum number of users on your licence.
Check your data connections
To make sure you have an active data connection:
Click AOI Administrator then click Data Connections.
Check if there's a data source showing under Data Connections.
If you need to create one, check out our How to create a Data Connection article.
Re-enable the Eel option in AOI Administrator
If the Access tab isn't showing, you can remove the Excel option in AOI Administrator and re-enable it.
Check your load behavior is set to three
It's worth checking your load behavior is set to three as this can be another cause for the Access tab to not appear.
Re-create all user settings
When creating the user, something may have gone wrong during the setup. Try re-creating the user settings.
Re-create the licencing database
If re-creating the user settings didn't work, try re-creating the licencing database.