Export to Excel 2013 is painfully slow

Hi,

Has anyone else run into this issue?   I'm trying to export a full receivables aging to Excel to do some analysis on it.  This is a very large file, with nearly 20,000 invoices, but...

Exporting to text takes around 1 second.   Exporting to Excel on an old Pentium IV workstation without Excel takes about 15 seconds.

This is the progress on Windows 8 / Office 2013, after 45 minutes:

Progress bars are notoriously difficult to program, so it's hard to be sure, but this looks like it has another 3 hours to go, so...

An export takes roughly 900 times as long to Office 2013, versus exporting in Excel 2.1 format.

Is there a setting in Excel, or in Sage 50, or in Windows, that anyone has come across, that will improve the speed?  

Thanks,

Randy

Parents Reply Children
  • 0 in reply to Richard S. Ridings

    Thanks Richard,

    I was using the Export to Excel option.

    I would think that it shouldn't be bothering with Excel during the Export process.  When using Export to Excel (97-2007 format) or Open In Excel, Sage 50 appears to use Microsoft Excel to build the Excel file.

    It seems to take the same amount of time, right up to either opening it for the 'Open In Excel' option, or not opening the output file for an Export.

    The stopwatch shows 2:20:55 now, and the progress bar's past the halfway mark.  Because it's using a third of a 4 core processor, it's used 2:52:09 of processor time. 

    (update, it took 3:26:04.27 to export 32,043 rows x 9 columns, so about 2.5 rows per second.)

    (Edit) this problem can be solved by turning off all animation in Excel.