SAP Knowledge Base Article - Public

1396199 - Error: "HsTbar.xla cannot be found. Check your spelling, or try a different path"

Symptom

  • Unable to Import Excel into Xcelsius 2008
  • Only happen with computer having Hyperion Smart View for Office installed
  • Error: "HsTbar.xla cannot be found. Check your spelling, or try a different path"

Reproducing the Issue

  1. Open Xcelsius 2008
  2. Click on Data -> Import -> Excel file  
  3. Full error message: "'\\zeus\home\003Home\nicodem1\My Documents\HsTbar.xla' cannot be found. Check your spelling, or try a different path."

Environment Information 

  • Business Objects Xcelsius 2008
  • Microsoft Office 2007
  • Microsoft Windows XP Pro SP2
  • Hyperion Smart View for Office (9.3.1.1.5.006)

Cause

Conflict between Hyperion Smart View for Office and Xcelsius used on the same computer.

Resolution

1.  Disable Hyperion Smart View for Office via Excel Add-ins.
2.  Copy HsTbar.xla from the following path:

C:\Program Files\Hyperion\Smartview\Bin\

3.  Paste the copied file from step 2 into the path stated in the error messages.

'\\zeus\home\003Home\nicodem1\My Documents\ 

4.  Open Xcelsius 2008
5.  Click on Data -> Import -> Excel file. 
6.  Excel file can now be import successfully.

Keywords

SmartView; Oracle Smart View  , KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Xcelsius Enterprise 2008