Hyperion Pillar Addin for Excel 2010

Posted on 2011-10-13
Medium Priority
Last Modified: 2012-05-12
Hi experts,

Our company has recently upgraded from Office XP to Office 2010.  Some of the users are now unalbe to use the Pillar Addin PllrSS.xla.  Receive the message "Object library invalid or contains references to object definitions that could not be found".  I have googled this using many different words and the only post I found related to deleting all .xld files, which did not resolve the issue.  Any thoughts?

Thanks in advance!!

Question by:Catt999
  • 4

Author Comment

ID: 36963572
Also get the message "Compile error in hidden module COptions.  The error commonly occurs when code is incompatible with the version, platfor, or architecture of the application.".  This occurs on a newly imaged system, no extra software installed (outside of base image installs).  It sounds pretty self explanatory but the strange thing is we have gotten it to work on ONE machine.  Not sure why it will not work on any others what so ever.  The one machine it is working on has a pretty old image so maybe that has something to do with it?  I am most definitely at a loss so really hoping someone has run across this before  :)

LVL 37

Accepted Solution

TommySzalapski earned 2000 total points
ID: 36963769
Have you contacted Hyperion to get the updated version of the add-in that supports Excel 2010?

Author Comment

ID: 36964758
Thanks Tommy for the response.  I have tried to find it on the web but am unable to .  And no, I have not contacted Hyperion.   From what my finance resource tells me is that there is absolutely no upgrades and/or updates being done for this since Oracle bought them out.  Probably why I cannot find any answers on the internet.  Will keep looking.

Author Comment

ID: 36964916

I was just working with one of our users and we were able to get this working.  Followed the instructions in http://blogs.msdn.com/b/ericwhite/archive/2009/07/22/object-library-invalid-or-contains-references-to-object-definitions-that-could-not-be-found-or-element-not-found.aspx and that seems to have done it.  Had to search a couple more places for the .exd files but that was minor.  

Thanks for responding to my post!!  I am awarding you the points.

Have a great day!

Author Closing Comment

ID: 36964923
Thanks again for the expert help!  Love this site.

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This holiday season, we’re giving away the gift of knowledge—tech knowledge, that is. Keep reading to see what hacks, tips, and trends we have wrapped and waiting for you under the tree.
If Skype for Business came with your office 2016 or office 365 installation, you may find that it's almost impossible to either disable or remove it. The application will often launch with each start of Windows, even when explicitly configured not t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question