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 |