XLSX in KP34, KP06, KP26

[h3n]

Hi,

I am using KP06 and KP26 for uploading Excel planning. In KP34 the Excel-integration is checked. With Office 2007 everything works fine. Some Days ago, we migrated to Microsoft 365. Of course, in excel the suffix of the files changed from xls to xlsx. The old file format with xls was denied through a policy. Now when I start KP26/KP06 I get the message SOFFICEINTEGRATION016. I think the KP06/KP26 tries to work with the old Excel Files xls. In the Table KPP1PHF I only see XLS files. My problem is how to migrate this old excel files in KP34 to XLSX files.

Kind regards, Henning

[Annemarie]

We are facing the same issue. Did you find a solution?

[Annemarie]

We got an answer form SAP:

If you cannot allow workbooks and templates of Excel 97-2003 in Office, please simply repeat step 1 ("Extract attached file and save extracted excel template _MASTE1.XLT to your PC") in the solution part of SAP Note 1826481 - but save file in XLTM format (instead of XLT format). Then also repeat steps 2 - 5 in order to import the XLTM Excel template file.

This solved our problem

[center100]

I had the same problem and SAP Note 1826481 solved it - (Thanks to Annemaria)

[h3n]

Hi Diyesh,

sorry, this is my mistake. In KP06/KP26 alle the excel inplace files are xls files. xls files are not allowed by policies. So, I must migrate all the xls files into xlsx files.

[h3n]

Hi there,

no one else has an idea how to start in KP26 an Excel as XLSX? My problem is that xls is denied by policies and I don’t know how to change the output in KP06/KP26 from an xls to an xlsx.

Regards Henning

[drbharucha]

Hello henning.schindler2

Saving XLSX file in lower version in excel, would be simple solution, which has xls extension.- Divyesh Bharucha