C cold New Member Mar 16, 2012 #1 Hi, I would like to know what is the maximum number of worksheets in one excel file. I know that the maximum number of rows is about 1 million but is it per worksheet? Thank you
Hi, I would like to know what is the maximum number of worksheets in one excel file. I know that the maximum number of rows is about 1 million but is it per worksheet? Thank you
SirJB7 Excel Rōnin Mar 16, 2012 #3 Hi, cold! 1048576 rows, 16384 columns, sheets number depend on memory available. Regards! PS: just press F1 in Excel (Help) and type "Excel limits".
Hi, cold! 1048576 rows, 16384 columns, sheets number depend on memory available. Regards! PS: just press F1 in Excel (Help) and type "Excel limits".
Luke M Excel Ninja Staff member Mar 16, 2012 #4 to add to what SirJB7 said, each sheet has that many rows and columns. Now, if you actually filled them all up with formulas, you'd better hope you have a super computer to handle all those calculations. <grin>
to add to what SirJB7 said, each sheet has that many rows and columns. Now, if you actually filled them all up with formulas, you'd better hope you have a super computer to handle all those calculations. <grin>
P Phuzzy New Member Mar 16, 2012 #5 And if you were to fill one cell per second, every second, it would take, by a rough calculation, 544 years.
And if you were to fill one cell per second, every second, it would take, by a rough calculation, 544 years.
