Click Office Button, Excel Options, Save, and change it to .xlsx

Carina wrote:

No. For some reason the default on my Excel 2007 is .xls. I can do file save
as or convert to .xlsx but it is annoying that everytime when i open up a new
excel session, i can only see 65,000 rows and in compatible mode.

"Sheeloo" wrote:


I thought that XLSX is the default format for Excel 2007.

How are you saving?
If you open an XLS file then it will be saved in the same format unless you
choose SAVE AS


"Carina" wrote:


I tried to change the file save format under Excel Options to .xlsx but it
only works on the current session. Once I close out and reopen, it switched
back to .xls.