When creating a new Excel workbook in 2007, only 65536 rows are shown. I
tried searching for all files with xlt or xltx and did not see a default new
workbook template to be modified, added, or deleted. The only templates I
found were the Installed Templates.

How can I get it to create new workbooks with all of the 1 million + rows?

Thanks