Sage 300

Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

65K row limit

Posted By Michael Ericksen over 8 years ago

I just attempted a Sales Report and received a warning about exceeding the 65K row limit. I am using Excel 2013 so that is not a limit from Excel. Is there something I need to do to get around this limitation?

0 Ettienne Schwagele over 8 years ago

Export it as an XLSX file, you're exporting as an XLS file which has the 65K limit.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 AXP over 8 years ago

If you are using 2012 or earlier versions of Sage 300 then the standard reports in Sage Intelligence are mostly setup with .xlt templates. You need to copy the report and then, after running the report, unlink and re-save the Excel Template as .xltx
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

65K row limit

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING