Skip to Content
Product Information
Author's profile photo Gustavo Munoz

FAQs – SAP Excel Add-in for C4C/ByD

This FAQ has purpose of responding most of the main questions and issues faced with the SAP Excel Add-in for C4C or ByD.

Please us know your opinion or any comment in the comment section.

1 – What is the error: “Error 500″ when performing a data upload?

This error is mostly related to the data in the template itself – which means you have entered a wrong data in the template and when the validation happens during the upload as the data is not correct for example a wrong UoM or ID) this error is shown.

2 – What are the system requirements to run the SAP Excel Add-in?

Windows 7 up to Windows 10 are supported (32 or 64 bits supported).
Microsoft Excel 2007 up to 2016 versions are supported (32 or 64 bits supported).
.NET Framework 4 or newer (you can download it here)
Microsoft Visual Studio 2010 Tools for Office Runtime

We are working to support Microsoft Office 365 cloud version. On premise version is supported.
MacOS enviroment is currently not supported.

3 –What is the error: “problem with this Windows Installer package. A program required for this install to complete could not be run. Contact your support personnel or package vendor” during SAP Excel Add-in installation ?

This error is due to a missing file from .NET Framework please try to reinstall .NET Framework (you can download it here)and after it try to install the SAP Excel Add-in.



Windows 10 has built-in .NET version 4.6.2 but sometimes some of the necessary files for the add-in to work are not present so you can do the following steps to try to fix this

1) Go to Control Panel in your PC
2) Open Program and Features
3) Open Turn Windows Features on and off
4) Check .NET Framework 3.5 (includes .NET 2.0 and 3.0)
5) Press Ok
6) Windows will download a small .cab application from Windows Update – install it and try again to install the SAP Excel Add-in


4 – After installation I don’t see the SAP Excel Add-in tab within Excel?

Some times Microsoft Office doesn’t enable the new Add-in to be visible. To make the tab visible please follow the steps below:

1) Open Excel
2) Go to File
3) Open Options
4) Go to Add-ins section
5) In Manage section please select COM Add-ins
6) Click Go
7) Check the entry SAP Add-in for Microsoft Excel
8) Press Ok

5 – What is the error: “Unable to cast COM object of type ‘Microsoft.Office.Interop.Outlook.ApplicationClass’ to interface type ‘Microsoft.Office.Interop.Outlook._Application’. This operation failed because the QueryInterface call on the COM component for the interface with IID ‘{00063001-0000-0000-C000-000000000046}’ failed due to the following error: Library not registered.” ?

The error is caused by a wrong registry file, this happens when you downgrade the version of Microsoft Office. e.g. 2010 to 2007.
Registry Key: HKEY_CLASSES_ROOT\TypeLib\{00062FFF-0000-0000-C000-000000000046}

Here you will see that you have for example folders with numbers: 9.3, 9.4 or 9.5 – it depends of the versions of the Microsoft Package.

Outlook 2007      9.3

Outlook 2010      9.4

Outlook 2013      9.5

So when you downgrade, these folders are not deleted, if you went from Office 2010 the 9.4 will be present together with 9.3 from Office 2007.

You can delete the folder related to the Microsoft Office which IS NOT installed in the computer.


If you have the 9.4 folder (from Office 2010) and you are using Office 2007 (folder 9.3). You should delete the folder 9.4, related to the Office 2010 that you do not have installed in your computer, inside the registry key.

6 – What is the error: “Invalid credentials; check your user and password” during SAP Excel Add-in Logon?

Please perform the following checks:

1) Check if system URL is correct under SAP System URL. some users by mistake type the URL and it has a blank space in the end.

2) Check if your username and password are correct.

3) Check with your administrator (also known as Key User) if your password is not blocked. (After the 3rd attempt or based in your company settings – the password will be locked in the system so the administrator will need to unlock it for you).

4) Check if your Proxy Settings are correct.

5) If do you use the Single Sign On feature check if the Certificate selected under Select Certificate is correct.

7 – What is: “Proxy Settings” within the SAP Excel Add-in tab?

In case your company use proxy for the internet connection management this options provides to you the opportunity to configure the proxy settings for connection to the system.

8 – You have the following error when the report opens “Starting SAP Report……..”:

1)Open Excel
2)Go to File
3)Open Options
4)Go to Trust Center
5)Open Trust Center Settings
6)Go to Protected View
7)Uncheck Enable Protected View for files originating from the Internet and Enable Protected View for files located in potentially unsafe locations.
8)Press OK
9) Try to open again the report from the system

9 – You trying to log via SSO in Excel Add-in and have the follow error:

Note that the SSO needs to be configured in the system itself (via the activities in the Application and User Management Workcenter in SAP Business ByDesign or in Administration Workcenter for SAP Hybris Cloud for Customer) if not properly setup the SSO environment this behavior will be shown in Excel Add-in during the Log On.

10 – You are working with a template and you dont see the option “Save data to”:

This behavior can have multiple causes the most common are:

1)You are using a old template (from a past system release and not the current):
Please download the latest template from system.

2)You are not using the latest Excel Add-in plugin:
Please update the SAP Excel Add-in plugin to latest version


11 – SAP offers a MSI file installer?

Yes, for such case please raise an incident and me or other support colleague will handover the file to you.

Note: We plan to offer it via the Download Center in the future.


Best Regards,

Gustavo Muñoz

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo kamalika Barua
      kamalika Barua

      Thanks for this article. It has helped with installing Excel Add-In.

      Author's profile photo Gustavo Munoz
      Gustavo Munoz
      Blog Post Author

      Hello kamalika Barua,

      Thanks for your input, glad that it help you!



      Author's profile photo Manuel Peschke
      Manuel Peschke

      Hi Gustavo Munoz ,

      Thanks for the great blog post, it helped a lot to troubleshoot issues with the Add-In.

      As we have a greater amount of users we would like to roll-out the Add-In via a silent deployment.

      Do you know if there is a MSI package available for the ByD Excel Add-In and a documentation for silent deployment?




      Author's profile photo Gustavo Munoz
      Gustavo Munoz
      Blog Post Author

      Hello Manuel,


      Thank you for the feedback!


      Yes, we are now offering a .MSI file for Excel as well.

      I would ask for you to raise an incident so I can send the file to you, you can mention to assign to me.

      Thanks and Regards,

      Gustavo Munoz

      Author's profile photo Manuel Peschke
      Manuel Peschke

      Thanks Gustavo!

      I have just created an incident and asked to assign it to you.




      Author's profile photo Stefan Rullang
      Stefan Rullang

      Hello Gustavo,

      what about the MacOS enviroment support.

      Is there still no support for MacOS? Is there anything planned for the future?



      Author's profile photo Gustavo Munoz
      Gustavo Munoz
      Blog Post Author

      Hello Stefan,

      The MacOS support was not yet in round map but I cannot comment, right now I am not part of the C4C-BYD Support anymore, I would advise you to raise a incident to check if this is in plan already.


      Gustavo Munoz

      Author's profile photo Gandalf Buscher
      Gandalf Buscher

      Hi and thank you for that blogpost.

      I recently read the C4C Releasenotes and it looks like that A2X is deprecated.

      Now I wonder if the Addin will be changed or is not affected by this, as i.e. already usind ODATA.

      Thank you and regards,


      Author's profile photo Gustavo Munoz
      Gustavo Munoz
      Blog Post Author

      Hello Gandalf,

      I am no longer part of the BYD-C4C support, I would advise you for this question to raise a new incident to support.

      I will keep the blog open as it is still relevant for the Add-in.


      Gustavo Munoz

      Author's profile photo Jiyeon Yoo
      Jiyeon Yoo

      Hi and thank you for that blogpost.


      The error I'm getting seems to be similar to #5 of your post.
      I can't find which registry I need to delete.

      I'll attach my error window. Can you find the cause?
      (I translated the Korean error window, so it may not be accurate.)

      error pop-up ---------------------------------------------- -----------------------------------------
      Update operation failed: error during Maintain

      operation: cannot cast COM object of type 'System.__ComObject' to interface type 'Microsoft.Office.Interop.Excel._Workbook'.

      Error loading type library /DLL. This operation cannot be performed because the QueryInterface call failed on the COM component of the interface with IID '{000208DA-0000-0000-C000-000000000046}' with error (HRESULT: 0X80029C4A (TYPE_E_CANTLOADLIBRARY) with exception: 0X80029C4A (TYPE_E_CANTLOADLIBRARY)).


      Thank you and regards,


      Author's profile photo Ankitkumar Kaneri
      Ankitkumar Kaneri

      Thank you @Gustavo for posting this blog, it is very helpful.