Usually the FormWork Tab is not visibile because the FormWork Excel Client has been disabled.
Below a series of common conditions that can determine this issue are listed.
Before any inspection close all open Excel instances (also check Excel processes in your Task Manager).
Most common checks
- Install Client and check prerequisites for installation
- Ensure that prerequisites are installed.
- Check "Formwork Excel Client" is present among the installed software.
- Open Excel and select File / Options / Add-ons
- From the combo box "Manage" select "COM add-ins" and then click "Ok"
- Check if Formwork Excel Client is listed and checked
- Open Excel and select File / Options / Add-ons
- From the combo box "Manage" select "Disabled Elements" and then click "Ok"
- Check wether the Formwork Excel Client is listed (in case activate it)
- Run regedit.exe
- Check for the key "HKCU\Software\Microsoft\Office\Excel\Addins\SDM_ExcelClient". (depending on the installation version, the key could also be "HKLM\Software\Microsoft\Office\Excel\Addins\SDM_ExcelClient")
-
Check the following keys exist:
- Default
- Description
- Friendly Name
- Load Behaviour
- Manifest
- Check the value of the Load Behaviour key: it shoud be 3
Check if there is a loading error
- Open My Computer Properties
- Click on Advanced Tab
- Click on the Environmental Variable
- Click on New User Variable
- Add VSTO_SUPPRESSDISPLAYALERTS with value 0 press OK
- Repair ISDM Excel Client from add/remove program
- Open Excel again, it will prompt an error message.
Uninstall and reinstall
If you still have trouble, uninstall and then reinstall the plug in.