Skip to Content
0

Export to Excel from ALV using Excel 2016 does not open the worksheet

Oct 07, 2017 at 12:23 AM

750

avatar image
Margaret Kreytak

Some of our users are now using Excel 2016 (32-bit) with GUI 7.40.

Whey they export to an Excel spreadsheet, the file is transferred correctly and Excel opens automatically. However, the newly downloaded file is not opened. The user must browse to the folder from within Excel and open the file.

Has anyone seen this behavior?

UI SAP GUI for Windows
ABAP Development | alv export
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
Best Answer
avatar image
Nic Teunckens Answered Oct 07, 2017 at 09:17 PM
1

First off :

  • The effects only occur when using Excel 2016?
  • Are there Users that use a Different OS (Windows 7 VS 8 VS 10 VS ...?) that do not have the issues?
  • The issue does not occur in other Gui-versions (as an example: no issue when using SAP Gui 7.3x in combination with Office 2016)?


Those suble differences could be of importance ...

Please check SAP-KBA 2445376 on :

  • The correct SP-level of SAP Gui version to enable a good collaboration with Excel 2016 ;
  • It references a set of SAP-KBA's that are relevant to Office Integration, so please take all this detail into account ...


Please revert back if you need more help OR want to explain what the solution is ...


Kind regards

Nic T.

Show 4 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Margaret Kreytak
Oct 09, 2017 at 06:56 PM

Hello Nic,

Thank you for your response. I have done additional research and testing.

I went back to SAP-KBA 2445376 to ensure that our SP-levels are adequate. I also read through all related SAP-KBAs that I could find. Unfortunately, I have not found anything that sheds light on this issue.

The effect only occurs with Excel 2016. Other versions of Excel work correctly. Excel Inplace mode does not have any issues.

The issue occurs with Windows 10 Pro when using SAP Gui 7.4x and 7.5x. I don't have any users with the combination of Excel 2016 and older versions of Windows, but I will set up some test systems to see if I can narrow down things further.

Again, thank you for your response. If you have additional suggestions, I would be glad to hear them.

Regards,

Margaret K.

0
Nic Teunckens
Margaret Kreytak
Oct 09, 2017 at 08:01 PM

Apparantly there are some Known Stability Issues with Excel 2016 as SAP-KBA 2518588 - "Stability issues when using Excel 2016" indicates ...

It might be some Registry Key issue? Maybe do a Google-Search on this?

PS : Microsoft itself has an Office Configuration Analyzer Tool (OffCAT) tool that could potentially help to gain insight? Never used it though ...

If none of those things helped, Contact SAP Support and raise an Incident.

1
Margaret Kreytak
Oct 09, 2017 at 10:27 PM
Ah, that is very interesting. Thank you for the pointer.

I will follow these leads.

0
Margaret Kreytak
Oct 17, 2017 at 03:31 PM

The solution was found using Microsoft's OFFCAT tool as you suggested.

Reinstalling Office 2016 solved the problem.

1
Comment