Author Topic: Increasing max rows not working for Excel formatted?  (Read 29 times)

Offline llopinto

  • Associate
  • **
  • Join Date: Jul 2012
  • Posts: 1
  • Forum Citizenship: +0/-0
Increasing max rows not working for Excel formatted?
« on: 14 Jun 2019 10:54:02 am »
in 10, I had updated the settings to allow 500k rows per worksheet with no problems.  It seems like in Analytics, it only works for Excel data, NOT excel with formatting.

Before you ask, I added these to ReportService, BatchReportService, and even the system advanced settings:

RSVP.EXCEL.EXCEL_2007_LARGE_WORKSHEET = TRUE
RSVP.EXCEL.EXCEL_2007_WORKSHEET_MAXIMUM_ROWS = 500000
RSVP.EXCEL.EXCEL_2007_OUTPUT_FRAGMENT_SIZE = 500000

Any help would be appreciated, thanks!

 



       
Twittear