How to default file save format to .xlsx in Excel?


C

Carina

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.
 
Ad

Advertisements

S

Sheeloo

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
 
C

Carina

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.
 
S

Sheeloo

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...
 
C

Carina

No, I don't have BOOK.xlt under XLSTART folder. The only file in this folder
is pdfmaker.xla
 
G

Gord Dibben

Sure you got the correct XLSTART folder?

You will have more than one.

The default for Excel's BOOK.xlt is

C:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART


Gord
 
Ad

Advertisements

C

Carina

Gord, Thanks for your replys. I checked under the path that you provided.
There aren't any files inside. I also did a search for "XLSTART" I have 2
hits under C:\Program Files\Microsoft Offices\Office 11 and Office 12 (
that's where i initially checked but no book.xlt). So, I search "Book.xlt"
under c:\ drive but no hit. Where else could it be?
 
G

Gord Dibben

One more try then I'm out of ideas.

Office Button>Excel Options>Advanced>General>At start up, open all files in:

Do you have a path entered?

If so, do you have a blank workbook.xls stored in that folder?

Move it out and/or delete the path in the dialog box, which I always do with
any version of Excel.


Gord
 
Ad

Advertisements

C

Carina

Gord, I don't have a path entered under the below. I guess we really ran out
ideas. At least we tried. Thanks for your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top