Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is your default template a custom template ? If not, simply delete it.
Also, it not sufficient to save your Book.xlt as Book.xltx. Daniel 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change file from xlsx to xls | Excel Discussion (Misc queries) | |||
How do I set default Excel Saveas file format to xlsx not xlsx | Setting up and Configuration of Excel | |||
How to change the default of 30 days change history | Excel Discussion (Misc queries) | |||
How can I change from the exel file extention .xlsx to .xls ? | New Users to Excel | |||
How do I change default template? | Excel Discussion (Misc queries) |