After installing Showcase Query, the ShowCase Query Excel Add-in was not attached immediately. When attempting to add it manually from the Tool | Add-ins menu, that is when the following error message appeared:
ERROR: scxadd32.xll is not a valid add-in.
Resolved by uninstalling and reinstalling MS Excel and ShowCase using the following steps.
- Uninstalled completely MS Office and ShowCase from the PC.
- Remove all the ShowCase Registry key located at: HKEY_CURRENT_USER\Software\ShowCase
- Re-Boot the PC.
- Re-installed MS Office and re-boot the PC.
- Reinstalled Showcase Client on the PC, re-boot the PC and then apply any Showcase Client patches.