A lot of XLSX reports crash Excel when using the Excel Sort function when using the autofilter funtionality.
We've niticed that editing the Excel slightly and saving it agan, solves the issue. Is JR writing the XLSX files wrongly?
Case: XLSX output, pagination off, auto detect type on, mixed excel types (dates, numbers, tekst, times), freeze row 2, autofilter on 1st row. 100+ lines of data.
Maarten @ Yesplan