Skip to Content

SAP-IBP Chart in 2005

Hi,

I recently updated to IBP Excel Plugin 2005 and I find that all my VBA Addin charts are no longer working, Anyone else faced this problem? This was not a problem back in version 1911.

Office Version: 2013 32-bit

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    Posted on Jul 29, 2020 at 09:07 PM

    Hi Sandy,

    I am not sure if you already figured out this issue, probably yes, but if not, please also troubleshoot it by following below KBA steps (even if you don't get the exact same error message):

    2806360 - IBP Excel add-in: SAP_IBP_Chart.xlam missing or not activated error message

    https://launchpad.support.sap.com/#/notes/2806360

    Best,

    Ivan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 20, 2020 at 08:37 AM

    Hello Sandy,

    they should we working as before. Please open a ticket @ component SCM-IBP-XLS-UI so that the support team can take a deeper look at it.

    Best regards,
    Anna

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 21, 2020 at 03:30 AM

    Hi Anna.

    Recreating the templates from scratch does not seem to help. What I do notice though is that it works with the other sample template, specifically with the "Chart10Columns_flexKF_2Sheets.xls" template, but not with the embedded or chart VBA add-in. Anyways, will create a ticket with SAP support.

    Thanks,

    Sandy

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 22, 2020 at 06:16 PM

    Hi Sandy,

    What do you mean by "they are no longer working" ? Kindly share more details on the behavior experienced to receive further assistance.

    Best,

    Ivan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 26, 2020 at 01:06 AM

    Hi Ivan,

    Here are the issues I'm encountering:

    1. Unable to add new KFs.
    2. Unable to add new filters.
    3. Unable to refresh the Chart.
    4. Unable to remove existing filters.

    Thanks,

    Sandy

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 30, 2020 at 10:51 PM

    HI Sandy,

    This is most probably because the VBA template contain Macros. So you need to make sure to click on that "Enable Content" yellow target message that Excel shows in a popup when you open the ".xlsm" file / template or adjust your Excel Macro settings in a permanent way that will allow any file to be directly opened:

    https://support.office.com/en-us/article/enable-or-disable-macros-in-office-files-12b036fd-d140-4e74-b45e-16fed1a7e5c6?NS=EXCEL&Version=90&SysLcid=1033&UiLcid=1033&AppVer=ZXL900&HelpId=xlmain11.chm458915&ui=en-US&rs=en-US&ad=US

    Best,

    Ivan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 03, 2020 at 01:32 PM

    Hi Ivan,

    Thanks for the reply bu that is not the case.

    1. ) The templates were in my Favorites and these were working prior the upgrade.

    2.) I made sure my Excel Macro settings were set to "enable all macros" even prior and during my creation of new templates.

    Regards,

    Sandy

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.