Exporting large summary file to Excel taking long time

[Neil_Million]

I've got multiple Filemake databases with 4m+ records each. I've created a layout which calculates a summary using a sort, Groups and Counts. This takes 10-15 seconds, which is OK.

However, when I try to export this summary report to Excel it appears that Filemaker has to recalculate all the Groups & Counts, but for some reason this takes several hours. The last report took over 4 hours.

I can't figure out how I can simply export or copy the summary report that Filemaker creates for the Layout?

Please can someone provide assistance because I have another 20 similar reports to do and this will take me days instead of hours

Edited April 26, 2016 by Neil_Million