Troubleshooting > Troubleshooting DataConnect > Maximum number of rows exceeded in sheet
Was this helpful?
Maximum number of rows exceeded in sheet
 
Error Code
30
Error Message
Sending updates to DMS: Maximum number of rows (1048576) has been exceeded in sheet ''.
Description
A worksheet in Microsoft Excel can contain maximum 1,048,576 rows and 16,384 columns. This limit is applicable on Office 365 and newer versions of Microsoft Office2019, 2016, 2013, 2010 and 2007. This error is usually displayed for connectors like Excel.
Cause/Solution
 
Cause: Microsoft Excel supports 1,048,576 rows and 16,384 columns.
Solution: You can write 1,048,576 rows at a time:
1. Click the Source tab.
2. Expand “Define Sample”.
3. Select “A range of records”.
4. Set the sample size “From” 1 “To” 1,048,576 rows.
5. Run the transformation.
Related Information
Excel specifications and limits
Last modified date: 12/03/2024