Are you having trouble exporting data from your instance into an Excel file? Do you find that all of your data is not exported or that portions of records are missing from your reports?

The reason for this misplaced data may be that the number of records you are trying to export is higher than the maximum number of rows that Excel allows. In some cases, even though all records have been exported successfully into the file, Excel will display only a certain number of rows if your data exceeds the limit.

Excel is intended for relatively small exports, generally 50,000 rows. Older versions of Excel can only export up to 65,000 rows while newer versions (Office 2007 or later) have a maximum limit of just over 1,000,000 rows. If your data number is larger than this, you may not be able to successfully export, and receive this notification: