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)

Note:
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.

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.

Example:

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.

Best Regards,

Gustavo Muñoz

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply