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.