You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Smart View add-ins query

Accepted answer
edited Apr 24, 2020 5:21PM in Essbase 1 comment


Hyperion Smart View - HsTbar.xla Excel add-in, HsAddin.dll COM add-in differences


Hi All,

Some of our users are facing  issue with existing macro enabled workbooks with 'Microsoft Visual Basic' runtime error - method 'Select' of object '_Worksheet' failed. We are suspecting some our monthly system windows patching is causing it. Oracle came back saying reimage machine which is a pain for lot of users.

When we disable "HsTbar.xla" Excel add-in, report is running fine as a work around. But "HsTbar.xla" Excel add-in comes back each time after we open excel. 

From what we have noticed, HsAddin.dll COM add-in alone is pulling data from hyperion. Do we know if we need both add-ins for Smart View to work correctly? Is there a place which highlights differences between these two add-ins? Is smart view install bringing in both add-ins?

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!