MS Excel 2016 SAP Business ByDesign Add-In on Win 10

[former_member201819]

Dear SAP Experts,

there is an Add-In for Microsoft Excel that can be donwloaded via "Self Service" page in Business ByDesign.

Unfortunately this is a very old version and the installation crashes with a cryptic error when I try to install it on my Win 10 environment.

Is there a new version compatible with Windows 10 and Excel 2016?

If so, where can I download it?

Kind Regards
Pablo Menth

[former_member201819]

Hi Alecia,

thanks for your hint. I just got another workaround hint which might be "almost the same".

That is, you can go into the folder where the old add-in is installed (e.g. C:programs(x86)\SAP\addin\Excel2007 AddIn...), therein you will find 13 files which represent the add-in.

For 2016, you would need to copy these files into a local folder on your C-drive, e.g. C:\Program Files\Microsoft Office\root\Office16\ADDINS\SAP ByDesign AddIn and then execute the file "sapExcelAddon.vsto", which is one of these 13 files.

Now when you open a blank sheet, you should see the new ribbon-menu on top.

Kind Regards
Pablo

[former_member341187]

Hello Pablo,

The add-in has been updated from the download center (self service as well)

In case you have issues to install I could see that Pierre quoted my FAQ about Excel Add-in above.

https://blogs.sap.com/2017/01/10/faqs-sap-excel-add-in-for-c4cbyd/

Best Regards,
Gustavo Muñoz

[Former Member]

Hi Guys

Had the same problem as you and found the solution to be the following:

FOR WINDOWS 10 USERS:

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 off4) 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

[Former Member]

I've encountered this same problem and the only solution we've been able to find has been:

- Install older version of Excel (2010, 2013).

- Install SAP ByD Excel add-in.

- Uninstall older version of Excel.

- Install Excel 2016.

The problems here being that you have to own an older version of MS Excel. Also, you run the risk of the add-in not working if you try upgrading it.

You can also access the add-in download file within SAP ByD by going to the "Application and User Management" work center, then "Download Center". This is an admin work center.