Skip to Content
Author's profile photo Former Member

Analysis functions from an Excel Add-In (xlam) causes exception if no workbooks open

I’ve got a series of Analysis workbooks that need to share common functionality, so I’m attempting to centralise most of the code in a VBA add-in. I plan to add more detail on SCN about my approach and experience once I’ve got more of it working.

One thing I’ve noticed, is that if I call some Analysis API functions from the add-in, while there aren’t any workbooks open, I get an error from SBO (see below). Why would I be calling an Analysis function if there aren’t any workbooks open? Because I need to set the visible/enabled status of controls on my own custom ribbon tab. For now, my workaround is to check if the Analysis add-in is connected, before I call an Analysis API function that causes this error.

It seems the error occurs when calling only some of the Analysis functions (Specifically the SAPGetProperty function) – I’ll update this post if I find any moe that cause the error.

If you’ve encountered this error, and/or discovered any workarounds or more detailed behaviours, please add your experience in the comments.

An exception occurred.

Send the attached log file to your administrator.

SAP BI Add-in will be closed.

If you want to save the data in the document, you must save a copy of the document because the data needed for  the addin functions cannot be saved correctly. (ID-102001)

AnalysisError.PNG

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi same error getting one user too.i am also waiting for solution.

      Author's profile photo Pavan Raj Sheshachala
      Pavan Raj Sheshachala

      Any solution? One of our user is having the same issue!

      Author's profile photo Igor Wagner
      Igor Wagner

      The same problem. Any updates?

      Author's profile photo Vadim Kalinin
      Vadim Kalinin

      Sorry, but it's an absolutely strange idea to post a comment to the blog written in 2013 by Former Member and wait for update 🙂 Also this is not a real blog, it's a question posted as blog...

      Post a new question and provide all details!

      Author's profile photo Girish Jagoo
      Girish Jagoo

      There seems to be a plausible solution to the above issue!

      check the link below for more information!

      Error ID-102001