"Jerry W. Lewis" wrote in message
...
Excel 95 and earlier had 16,384 = 2^14 rows.
Excel 97 through Excel 2003 had 65,536 = 2^16 rows.
Excel 2007 has 1,048,576 = 2^20 rows.

These numbers cannot be altered in any way (either up or down). In
particular, Gordon is correct that the issue is not the number of rows in
Excel, but rather what the OP is trying to do relative to the setup of the
template,

We don't even know that the OP is using a template!
(I never used to, for balance sheets......)