We have a report that delivers data, but it's too many rows for one sheet of excel. Currently we run three separate occurences that deliver different sections of the report. Is there a better way? I would like to be able to deliver the whole report in one workbook, with the data segragated by row numbers.
Any ideas?
There was a trick that used pagebreaks and rowcounts, but I'm unabel to find it at the moment ... Anyone?
Not that this is a solution, but how is someone consuming more than 66,000 rows in a single file?
Is the issue that the report is just not fully developed yet? What I mean to say is, what is the consumer doing with the file once it is in Excel? Surely they must then be working with it and summarizing it in order to get some value from the data. If you could replicate the work they are doing in the report, then that might serve everyone better.
We do summary reports as well, but we also archive data files in Excel for other purposes. Any additional help would be appreciated.
If it is for archiving only, then save it a CSV and don't bother with Excel.