Enable ability to export Rollup reports without detail data

Whenever I export a rollup report to excel and want to copy the data to a new sheet, it also copies all of the hidden detail rows. This negates the whole point of running a rollup report which is to be able to view and manipulate the data from the rollup accounts.