We have produced a report in reporting services that we want people to use as an 'extract' in excel for doing their own pivots and analysis.
We've tried to remove most formatting, but when the report is exported to excel after rendering, the file size is very large. I presume it is because there is formatting on every cell?
Is there a way to remove formatting? We've investigated exporting as CSV, but excel doesn't open the file nicely (need to to text->columns afterwards).
Is there some way around this? Thanks.