Export to Excel | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Export to Excel

When I Export a report to Excel I get a separate worksheet for each page on the report.
I need to Export all the data in ONE worksheet. Is it possible to do this with a simple setting? Thanks
Setting pagebreaks in your table will cause a new sheet for every pagebreak when exported to Excel. thanks