Get an out of memory error running a Sage Intelligence report off AR History detail created in the Connector.  This would generate a Pivot Table.  I have it filtered to limit to a date range, for example one month.  While the detail would be 251,000 rows with 12 columns, the report 'chokes' and up pops the out of memory error before it completes the process.  This is being run on the server, Excel ver 2013, plenty of memory.  As suggested in MS KB articles, I cleared all data/formats from the rows below and to the left of the data set on Sheet 1, still get this error.  We haven't exceeded the Excel row/column limit.  Any ideas what to try next?

tia