Troubleshoot the Engagement Manager web add-in
You can include information from Engagement Manager in your Microsoft Word and Excel files by using the Engagement Manager web add-in. Read through the following information and follow the steps to help troubleshoot problems with the Engagement Manager web add-in.
note
Engagement Manager has 2 Microsoft Office add-ins. The steps you use depend on which add-in you have installed:
- Engagement Manager desktop add-in (COM add-in):You have a separate Engagement Manager tab in Word or Excel.
- Engagement Manager web add-in:You select Engagement Manager from the Home tab and the Engagement Manager functions open in a side panel.
Only 1 add-in should be installed and active at a time. If you're using the desktop add-in (COM add-in), refer to Troubleshoot the Engagement Manager Add-ins (desktop COM add-in).
Common add-in problems for GoFileRoom or Engagement Manager
The GoFileRoom and Engagement Manager add-ins have key differences that affect how an issue should be resolved. Because all Engagement Manager documents are housed within GoFileRoom, you first need to identify which add-in is causing the problem.
Problems with the Engagement Manager web add-in:
- Values from the engagement won't add or update
- Descriptions won't import
- #NAME is displayed in Microsoft Excel spreadsheets
- The error “Unable to open Accounts.xml” is displayed
- All buttons in the add-in panel are turned off
- Recalculate takes an abnormal amount of time, or you get Recalculate Failed
Problems with the GoFileRoom Client Add-In:
- Unable to open documents
- Unable to edit documents
- Unable to save documents
Basic troubleshooting for Engagement Manager and GoFileRoom add-ins
Follow these steps to help identify problems with the Engagement Manager and GoFileRoom add-ins.
- Make sure you're following all settings with the GoFileRoom and Engagement Manager setup checklists.
- Make sure the Engagement Manager web add-in displays in Microsoft Word and/or Excel.
- If the add-in doesn't appear, it may have been removed or may not be available in the current Office session.
- Make sure that the document has been added to an engagement within Engagement Manager. The document must be added to an Engagement Manager engagement to use the following add-in functions:
- Engagement Link
- Workpaper Reference
- Procedure Completed
- Checkmark
- Recalculate
- Load Tickmarks
The Engagement Manager web add-in is installed, but not working
The add-in should load for any Word or Excel file that is included in an engagement within Engagement Manager, then opened for editing (through either GoFileRoom or Engagement Manager).
- Close Microsoft Word and Excel.
- Open Microsoft Task Manager and close any open sessions of Microsoft Word or Excel.
- Open the file for editing again.
note
If you open a document outside of Engagement Manager or GoFileRoom, the add-in won't be available to use.
All buttons in the add-in panel are not available
This issue is typically caused by Microsoft Office opening your file in Compatibility Mode. Compatibility Mode can occur when:
- Your workpaper is a legacy file type, such as .xls or .doc instead of .xlsx or .docx.
- Your workpaper uses macros but isn't saved as a macro-enabled file type, such as .xlsm or .docm.
Check whether the open file is in Compatibility Mode
- Look at the file name in the title bar.
- If it ends in .xls or .doc, the file is a legacy format.
- If it shows [Compatibility Mode] in the title bar, Office is running the file in Compatibility Mode.
- In Word or Excel, selectFile, thenInfo.
- IfCompatibility Modeappears on this screen, Office is running the file in Compatibility Mode.
Convert the workpaper to .docx/.xlsx (or .docm/.xlsm for macros)
Follow these steps to convert the file and re-upload it to Engagement Manager so the web add-in buttons are enabled.
- Close the document in Word or Excel.
- In Engagement Manager, open the engagement and select theWorkpaperstab.
- Right-click the workpaper, then selectExportand choose to export in the original format.
- Open the exported file from your Downloads folder.
- Select , then save the file as one of the following:
- .docx (Word) or .xlsx (Excel) for standard files
- .docm (Word) or .xlsm (Excel) for macro-enabled files
- Close the document.
- In your Downloads folder, delete the old exported copy (for example, the .doc or .xls version). Keep the newly saved .docx/.xlsx (or .docm/.xlsm) copy.
- In Engagement Manager, delete the original workpaper from theWorkpaperstab.
- Upload the new file to theWorkpaperstab using one of the following methods:
- Drag and drop the file into the target folder on the Workpapers tab.
- Select , then chooseExternalas the source.
Fix formulas showing #NAME or #BUSY
- After installing the web add-in, open a workpaper that contains Engagement Manager formulas (including custom Excel workpapers).
- Sign in to the web add-in with your credentials.
- Select theRecalculatebutton in the add-in.
- #BUSY may appear temporarily while the formulas process. This is normal Excel behavior during formula calculations.
- Larger workpapers or those with many formulas will take longer; let the process finish without making edits.
- Once the formulas have been updated correctly, save the workpaper as you normally would (save to GoFileRoom).
- Saving preserves the association between formulas created with the desktop add-in and the web add-in.
- It also prevents this issue from reappearing the next time you open the workpaper.
- Do this once for each workpaper that contains Engagement Manager formulas (including custom Excel workpapers).
- If you skip thesave to GoFileRoomstep, affected cells may continue to show #NAME the next time you open the workpaper, and you'll need to repeat the previous steps.
Recalculate takes an abnormal amount of time, or “Recalculate Failed” appears
If Recalculate is unusually slow or fails, reduce the size of your workbook by removing unused blank rows and columns. Do this on each worksheet.
- Open the Excel workpaper.
- Select the 1st blank row under your working area.
- SelectCtrl+Shift+Down Arrowto select all blank rows.
- Right-click a selected row number and selectDelete.
- Select the 1st blank column to the right of your working area.
- SelectCtrl+Shift+Right Arrowto select all blank columns to the right.
- Right-click a selected column letter and selectDelete.
- Repeat these steps for each worksheet, then save the workpaper to GoFileRoom.
note
Recalculate performance issues and failures can also occur when the file is in Compatibility Mode (for example, XLS).
Check Microsoft Office version (Office 2019 or later)
If the previous steps don't fix the problem, continue with these steps:
- Confirm you're using a supported version of Microsoft Office for the Engagement Manager web add-in (Office 2019 or later, including Microsoft 365 desktop apps).
- Make sure that Microsoft Word and Excel are up to date.
- Go toC:\Program Files (x86)\Microsoft Office\Office [YY].
- Right-clickEXCEL.EXEorWINWORD.EXE.
- SelectRun as administrator.
Turn off other add-ins that may be causing a conflict
Follow these steps to turn off other add-ins that may be causing problems with Microsoft Office.
- In Microsoft Word or Excel, selectFile,Options, thenAdd-ins.
- In theManagesection, selectCOM add-ins, thenGo.
- Turn off any add-ins that you aren't using.
Remove the Engagement Manager desktop add-in (COM add-in)
If the legacy desktop add-in is still installed, it can cause issues with the web add-in, including calculation problems. Follow these steps to remove the desktop add-in and confirm it's no longer loaded in Office.
- In Windows, selectStartand search forAdd or remove programs.
- FindEngagement Manager Client Office Addinsand uninstall it.
- Open Word and/or Excel.
- Select .
- In theManagedropdown, selectCOM Add-ins, then selectGo.
- Make sureEngagement Managerand/orAdvanceFloware not listed.
- If they are listed, select them and selectRemove.
- In Excel only: on the same Add-ins screen, selectExcel Add-insin theManagedropdown, then selectGo.
- Make sureEngagement Manager Automation FNSis not listed.
- If it is listed, clear the checkbox.
Uninstall and reinstall the Engagement Manager web add-in
Follow these steps to remove and reinstall the Engagement Manager web add-in in Word or Excel.
Uninstall
- In Microsoft Word or Excel, locate theEngagement Managerbutton on theHometab.
- Right-click theEngagement Managerbutton and selectRemove.
- If you don't have the remove option on the ribbon:
- SelectAdd-inson theHometab, then selectMore Add-insat the bottom of the menu.
- SelectMy Add-ins.
- Select the ellipsis (...), then selectRemove.
- Close and reopen Word or Excel to confirm the add-in is no longer visible.
Reinstall
- SelectAdd-inson theHometab in Word or Excel.
- Search forEngagement Manager.
- Select the add-in with the Thomson Reuters logo and publisher, then install it.
- Sign in when prompted.
Uninstall and reinstall the GoFileRoom Client Add-In
Follow these steps to uninstall and reinstall the GoFileRoom Client Add-In, used by both GoFileRoom and Engagement Manager.
- Open theControl Panelon your computer, then selectPrograms and Features.
- SelectGoFileRoom Client Add-In, thenUninstall.
- Restart your computer.
- Go toC:\Program Files (x86)\GoFileRoomand delete all folders except the following:
- GFRScanflow
- GFRUploadDocuments
- GFRImporter
- GFRLookupListSync
- Go toC:\ProgramData\GoFileRoomand delete all folders except the following:
- GFRScanflow
- GFRUploadDocuments
- GFRImporter
- GFRLookupListSync
noteThe ProgramData folder is hidden by default. Follow these steps to show hidden folders. - Go toC:\Users\[your username]\AppData\Roaming.noteThe AppData folder is hidden by default. Follow these steps to show hidden folders.
- Rename theGoFileRoomfolder toGoFileRoomOLD.
- Open theThomson Reutersfolder. If theWorkFlow Managerfolder is present, rename it toWorkFlow ManagerOLD.
- Make sure that you meet all the requirements listed in the GoFileRoom setup checklist.
- Sign in to GoFileRoom.
- Select your name thenClient Add-In.
- Choose to save the file when your internet browser asks what you want to do with the file.
- After the download is complete, right-click on the file and selectRun as administrator.
- Follow the prompts to reinstall the GoFileRoom Client Add-In.
What happens next
- If the issue was caused by Compatibility Mode, converting the file to .docx/.xlsx (or .docm/.xlsm) typically restores add-in functionality.
- If the issue was caused by the legacy desktop add-in, uninstalling it typically prevents conflicts with the web add-in.
- If the issue was caused by the GoFileRoom Client Add-In, reinstalling it typically restores document open/edit/save actions from GoFileRoom and Engagement Manager.