Never mind, I have found the answer that was posted under the same question over 4 years ago.
Version: 11.8
A user has scheduled a report that generates around 5,500 records. However, when he receives the emailed .xlsx spreadsheet, the header displays…