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.

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.

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.

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.

No. For some reason, my excel 2007 default is .xls. I know i can do save as
or convert to .xlsx but it is annoying that everytime when i open up a new
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.

Are you saying that even if you create a new workbook and save it for the
first time, it gets saved as XLS?

Pl. confirm.

Also describe the steps you take to save...

"Carina" wrote:

No. For some reason, my excel 2007 default is .xls. I know i can do save as
or convert to .xlsx but it is annoying that everytime when i open up a new
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.

Correct, when i save it for the first time it gets saved to .xls. I have to
remember to save the file type as .xlsx everytime when i create a new excel
file.

"Sheeloo" wrote:

Are you saying that even if you create a new workbook and save it for the
first time, it gets saved as XLS?

Pl. confirm.

Also describe the steps you take to save...

"Carina" wrote:

No. For some reason, my excel 2007 default is .xls. I know i can do save as
or convert to .xlsx but it is annoying that everytime when i open up a new
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.

Do you have a file named BOOK.xlt in your XLSTART folder lefy over from an
earlier version of Excel?

When I installed 2007 after 2003, 2007 used the BOOK.xlt I had stored for
2003.

Consequently all new workbooks in 2007 were 2003 mode.

I had to remove BOOK.xlt from the XLSTART folder in order to get the 2007
default workbook.


Gord Dibben MS Excel MVP

On Fri, 6 Feb 2009 13:08:02 -0800, Carina
wrote:

Correct, when i save it for the first time it gets saved to .xls. I have to
remember to save the file type as .xlsx everytime when i create a new excel
file.

"Sheeloo" wrote:

Are you saying that even if you create a new workbook and save it for the
first time, it gets saved as XLS?

Pl. confirm.

Also describe the steps you take to save...

"Carina" wrote:

No. For some reason, my excel 2007 default is .xls. I know i can do save as
or convert to .xlsx but it is annoying that everytime when i open up a new
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.