Share via

Excel 2016 XXL format export

Anonymous
2016-09-21T22:04:17+00:00

I have a Win10 box with Office 2016.  I am in SAP and exporting to XXL format from within SAP and everything works until the export is larger than 65k~ish lines (which I think is the old SAP limit).  I don't see the app opening in compatibility mode either.  Has anyone run across this issue inside of Excel?  Everything works on a pc with 2013 or 2010.

I am wondering if there is a setting somewhere to tell Excel to open with the new 1 million ~ish limit vs the lower limit.  I have tried changing the option to save as an xlsx but the customer is wanting to export as XXL format.

Thanks,

Patrick

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-12-20T05:06:20+00:00

    Dear Patrick,

    There is a SAP note but I cannot remember the number.

    Basically you need to enter a line of code in function module XXL_FULL_API that reads

    REGISTRY_LOOKUP2 EQ 'Excel.Application.16'

    I suspect you have a line which reads

    REGISTRY_LOOKUP2 EQ 'Excel.Application.14' that allows opening 1 mil. records in MS-Excel 2013.

    I hope this helps.

    Best regards,

    Pascal.

    2 people found this answer helpful.
    0 comments
  2. Anonymous
    2016-09-22T15:42:45+00:00

    Hi Patrick,

    Your post is more advance than what we usually encounter here in our community thread. That is why to better assist you with this concern, may we request you to post this inquiry in one of our advance support site. You can get in touch with them in this link: https://msdn.microsoft.com/en-us/

    Let us know how it goes. Thanks.

    1 person found this answer helpful.
    0 comments