Forum Discussion
ssgchen
Jan 30, 2022Copper Contributor
How to change the default template that is used whenever I create a new .xlsx file?
I have created a workbook that I would like to use as a template for all new .xlsx files that I create from file explorer. I have read several guides online and almost all of them say the same thing....
- Jan 30, 2022
Ah - that won't work. The template you get by selecting File>New>New Blank Template is a built-in template that cannot be changed.
Book.xltx will be used when
- You start Excel.
- You press Ctrl+N.
- You click New on the Quick Access Toolbar.
ssgchen
Jan 30, 2022Copper Contributor
Ah I see, thanks for the clarification. I just tested out all three methods. It doesn't work when I start Excel, but it works when I press ctrl+N and click new on the Quick Access Toolbar! Do you know why that could be the case?
HansVogelaar
Jan 30, 2022MVP
I don't know why it doesn't work when you start Excel.
- ssgchenJan 30, 2022Copper ContributorOk, thanks for your help!