We have Excel 2007 at work. The default setting for new sheet that shows when Excel is opened is "Excel 97-2003 Workbook". When I go into Excel options to change the "Save" settings to "Excel Workbook" it changes for this session only. When I go back into Excel the next day, the previous settings or the default settings are back to "Excel 97-2003 Workbook"

How can I change the "Save" settings so that when I go back into Excel, the empty workbook is the new sheet with million rows and not the old one with only 65k rows.

Appreciate your guidance.

KS.