Skip to Content

Issue with ByDesign Excel Addin 2927

Shortly: newest addins cannot refresh old Excel-based reports, developed using early SAP ByDesign Excel addin.

My situation:

I have several prod tenants for subsidiaries and many Excel-based reports in each.

All of those workbooks were developed using SAP ByDesign Excel addin version 2109.

And all of them can be opened using 2109 without any issues.

However, when I open same Excel-based reports using newest addins (2855 or 2927, Excel version is the same, just addin version is different):

some reports cannot be refreshed at all (addin simply stops after opening file and doesn't start refresh process),

some reports shows critical errors like

Nevertheless, after click "OK" - refresh process continues. However, it can confuse end-users, in the end, I wouldn't trust report results after critical errors during execution.

What makes this issue even worse - version 2109 cannot be installed when only Office 2016 is installed on workstation, as setup file for 2109 was produced in 2014, it makes check of installed Office version during installation. Of course, it knows nothing about version 16.0 and stops process.

I know about workaround (https://answers.sap.com/questions/59309/ms-excel-2016-sap-business-bydesign-add-in-on-win.html) but it is not acceptable for big organization.

Secondly, re-creation of all Excel-based reports from scratch using newest addin will take enormous amount of time - so, not a solution.

Does anyone encounter the same issue? Any ideas, secret settings, registry keys, something that can help with upgrade?

Thanks in advance,

Ivan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers