Forum Discussion
Where is the default Excel Template directory on Windows 10?
Here is the default location for Office 2016, 2013, 2010, and 2007 on Windows 10, 8, 7, and Vista
The location is C:\Users< Username >\AppData\Roaming\Microsoft\Templates\Document Themes
For more details visit this link >>>> https://support.microsoft.com/en-us/office/customize-how-excel-starts-6509b9af-2cc8-4fb6-9ef5-cf5f1d292c19
Here is the default location for Office 2016, 2013, 2010, and 2007 on Windows 10, 8, 7, and Vista
The location is C:\Users< Username >\AppData\Roaming\Microsoft\Templates\Document Themes
For more details visit this link >>>> https://support.microsoft.com/en-us/office/customize-how-excel-starts-6509b9af-2cc8-4fb6-9ef5-cf5f1d292c19
Amusing the folder location given in the response's body differs from the folder location in the link in the response. C:\Users\Dave Challis\AppData\Roaming\Microsoft\Templates or Templates\Document Themes
I have placed a personalized Book.xltx and Sheet.xltx in both folder locations. Unfortunately, I found neither work.
Using Win 10 and Excel 365.