Create new worksheet in workbook during export of > 65k rows

[daughtery]

I have a report that has over the maximum limit of rows that can be exported to Excel. Is there a way to create a page break after say row 60k, add another worksheet, and fill the rest of the rows on the second worksheet?

 

[synapsevampire]

No.

-k

 

[dgillz]

One of my favorite questions: Why export to excel?

I never get a good answer to this question but I would like to hear yours.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[IdoMillet]

Consider a 3rd-party tool. See list at:

http://www.kenhamady.com/bookmarks.html

If the report is grouped by something at level 1, my "Visual CUT" software can send the content of each group to a separate tab within a single workbook.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[daughtery]

Because they want it to...haha.