Troubleshooting Office Connector
Office Connector is a third party Excel Add-In used to run reports and export data from Timberline.
The Office Connector Add-In is installed on the Session Desktop. If you do not use it frequently or have never used it before, the add-in may need to be loaded on your user profile.
To verify the add-in is Loaded
Open Excel on Session Desktop > open add-ins on the ribbon > below is what it should look like. If you do not have the add-ins option option at all, you have no add-ins loaded.
Another way to verify the add-in is loaded; open Excel on Session Desktop > file > options > add-ins > confirm you see "Office Connector" and "Office Connector Import" under "Active Application Add-Ins".
To Load the Office Connector Add-In
If you verified the add-in is NOT loaded, you can load it by; opening Excel on Session Desktop > file > options > add-ins > make sure "Excel Add-Ins" is selected at the drop down > click Go > browse >
Navigate to C:\Program Files (x86)\Event 1\Office Connector\OfficeConnector.xla for Office Connector
Navigate to C:\Program Files (x86)\Event 1\Office Connector Import\OfficeConnectorImport.xla for Office Connector Import
Verify both add-ins are check and click OK > at the add-ins menu you should see both listed under "Active Application Add-Ins" like the screenshot above.
To Reset the Office Connector Tool Bar
If you verified the add-in IS loaded but are still having issues like report not prompted for Timberline log-in, missing options from add-ins menu, etc; there is a built in reset function to restore the add-in.
To reset the Office Connector add-in; open a blank Excel workbook on Session Desktop > type in one of the empty cells =OCRESETTOOLBAR() > make sure you include the () at the end > press the tab key > it will fill the cell with a 0 and the add-in will be reset.
