change default to xlsx



I would like to change the default file format from .xls to .xlsx. Based on
suggestions in other threads, I've changed the template, Book.xlt, to
Book.xltx. Also, I deleted Personal.xls keeping only Personal.xlsm. I've
gone to Excel Options and changed the "Save files in this format" to .xlsx,
but that only seems to work for the current session. If I close Excel and
reopen it, the default is .xls.

The only good news is that changing the template and deleting Personal.xls
seems to have gotten rid of the compatibility mode issue, but it would be
nice to not have to select .xlsx every time I save a new file.

Any suggestions are greatly appreciated.


Is your default template a custom template ? If not, simply delete it.
Also, it not sufficient to save your Book.xlt as Book.xltx.

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