Fixing Function Links After Smart ViewSmart View Reinstallation in a New Location

When Smart View is reinstalled in a new location, functions may fail. Use Excel Add-ins to delete the old HsTbar.xla link, restart Excel, reconnect, and use Smart View’s "Fix Links" to update function definitions.

When connected to an Oracle Smart View for Office provider, such as Tax Reporting in Oracle Fusion Cloud Enterprise Performance Management or Essbase in EPM System, and using functions on a machine where Smart View was reinstalled in a different location (for example, originally Smart View was installed in the default installation location and then, on the same machine, Smart View was reinstalled in a user-specified, non-default location), the functions may not work correctly after reinstalling Smart View. To fix this issue, perform the following steps:

  1. In Excel, go to File, then Options, then Add-ins, then Excel Add-ins, and click Go.

  2. In the Add-ins dialog, select the check box for Hstbar. This gives an error message stating that "the HsTbar.xla file is not found in the location. Do you want to delete it?" Click Yes to delete it.

  3. Close and relaunch Excel.

  4. Open the saved workbook and connect to the data provider.

  5. In the Smart View ribbon, go to Functions, and then Fix Links.

    Fix Links updates the function definitions.