新Excel工作簿中的行太少-CSDN博客

In Excel 2007 and Excel 2010, when you create a new workbook, there should be 1,048,576 rows on the worksheet.

在Excel 2007和Excel 2010中，当您创建新工作簿时，工作表上应该有1,048,576行。

However, one of my clients was creating new files in Excel 2007, and the sheets only had 65,536 rows, just as they did in older versions.

但是，我的一位客户正在Excel 2007中创建新文件，工作表只有65,536行，就像在旧版本中一样。

Perhaps you don't need more rows than that, but if you've paid for a shiny new version, you'd like access to all of its features!

也许您不需要更多的行，但是如果您购买了一个闪亮的新版本，则希望使用它的所有功能！

解决行数太少的问题 (Solve the Too Few Rows Problem)

At first, we thought the problem might be an old Excel 2003 template, that was starting automatically, and being used for the new workbooks. A search of all the Templates folders didn't turn up any suspects, so that theory was wrong.

最初，我们认为问题可能是旧的Excel 2003模板，该模板会自动启动并用于新工作簿。搜索所有Templates文件夹并没有发现任何可疑对象，因此该理论是错误的。

Finally, we discovered that the default format for saving files was set to Excel 97-2003 Workbook (*.xls).

最后，我们发现保存文件的默认格式设置为Excel 97-2003 Workbook(* .xls)。

To get the full-sized Excel 2007 worksheets, go into the Excel Options, and in the Save category, select one of the newer formats as the default for saving files.

若要获取完整的Excel 2007工作表，请进入“ Excel选项”，然后在“保存”类别中，选择一种较新的格式作为保存文件的默认格式。