Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

XXL Export with Excel 2016

I have run into an issue with a Windows 10 box with Office 2016 and Gui 7.40.  We are trying to export a report with 70,000 lines.   SAP is giving me an error that the results are too large to export.  I know the earlier Excel versions had a 65,000 line limit roughly.  I am trying to export as XXL.  A PC with win 7 and office 2013 works with Gui 7.4.

If I export as XXL with under the 65,000 limit it works fine on the Win 10 box as well.  It is just a hard limit somewhere inside of either SAP or Excel.  I have verified that we have the SAP note that expands the limit for Excel 2007 and later.

Has anyone run across this by chance?  I am trying to figure this out before it gets rolled out company wide.  Excel doesn't seem to be running in Compatability mode either.

Thanks,

Pat

Not what you were looking for? View more on this topic or Ask a question