725 views

Troubleshooting Export – Determine if the version of Excel cannot handle the data set size

 

Problem

This issue is related to exporting data from the instance into an Excel file. When opening the Excel file, not all records are shown.

 

Symptoms


  • Not all data exported
  • Records are missing from export
 
Cause

The number of records exported is higher than the number of rows that Excel can show. So, even though all records have been exported successfully into the Excel file, Excel can only show a certain number of rows.

 

Note: Until Office 2007, Excel had a maximum of 65,000 rows. In Office 2007 and later, the limit is 1,048,576 rows.

 

 

 

Resolution 


To solve the issue and display more than 65,000 records in Excel, upgrade to Excel version 2007 or higher.

 

Note: To export and view more than 1,048,576 rows, export into a different file type such as CSV or XML.

 

 

 

Article Information

Last Updated:2017-03-09 22:07:27
Published:2014-05-09