When using SmartView, an Excel add-in for Hyperion Planning, you get an error message that "C:\Hyperions\SmartView\Bin\HsTbar.xla" could not be found.
First, check if you have the latest version of SmartView installed. This version will have a menu option of "Smart View" in Excel. The older version of SmartView will have a menu option of "Hyperion" in Excel.
If you have the latest version of SmartView installed, you can use the following instructions to resolve the problem:
- Close Excel if it is currently open.
- Use Windows Explorer to navigate to this directory: C:\oracle\SmartView\install
- Run the "removeExcelOpenKey.vbs" file
- Close the window
If SmartView is an older version or is no longer needed, your technical support person can help remove the reference to Hyperion (SmartView) from Excel using the "removeExcelOpenKey.vbs" script found in the zip file below: