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
- Open Xcelsius 2008
- Click on Data -> Import -> Excel file
- 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 , Obsolete: BusinessObjects Dashboards and Presentation Design , Problem