Nov 22 2022 06:32 AM
Nov 22 2022 01:51 PM
An Excel worksheet has 1048576 rows and 16384 columns. This is hard-coded and cannot be changed. So you'll have to keep on splitting the data into multiple sections.
Nov 23 2022 12:13 AM
Thank you Hans, maybe Microsoft would consider making Excel more flexible and allow the user to define the boundaries, I did read that a work sheet is only saved using the formatted cells to save memory so maybe there is a mechanism!? It's a very inefficient method to work through these sheets and re assemble the whole thing at the end. I have made tools in Python before , so back to the learning curve to make this a straight forward exercise that others can make use of without in depth knowledge.
Nov 23 2022 03:33 AM
You can submit a suggestion to Microsoft from within Excel, by selecting File > Feedback > Send a suggestion, or by voting for The maximum row of excel is 1048576. Yes. Can you increase the number of rows?
Nov 23 2022 09:48 AM