Home

using custom template when starting a new book

%3CLINGO-SUB%20id%3D%22lingo-sub-361955%22%20slang%3D%22en-US%22%3Eusing%20custom%20template%20when%20starting%20a%20new%20book%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-361955%22%20slang%3D%22en-US%22%3E%3CP%3EI%20know%20how%20to%20create%20a%20custom%20template%20or%2C%20in%20general%2C%20how%20to%20force%20excel%20to%20start%20from%20a%20custom%20template.%20So%20that%20works%20when%20you%20double%20click%20to%20start%20Excel%3B%20I%20can%20get%20it%20to%20start%20with%20my%20preferred%20fonts%2C%20color%20palette%2C%20and%20so%20on.%20Nice.%3C%2FP%3E%3CP%3EWhat%20I%20don't%20know%20is%3A%20once%20the%20Excel%20program%26nbsp%3B%20is%20up%20and%20running%20and%20you%20want%20to%20open%20a%20new%20book%20from%20scratch%20%26gt%3B%26gt%3B%20select%20%22File%22%20then%20%22new%20book%22%2C%20then%20Excel%20opens%20a%20fresh%20new%20book%20indeed%2C%20but%20NOT%20FROM%20THE%20SAME%20TEMPLATE%20IT%20HAD%20STARTED%20IN%20THE%20FIRST%20PLace%20or%20for%20that%20matter%20any%20template%20available.%3C%2FP%3E%3CP%3EI%20have%20previously%20checked%20all%20possible%20*.xltx%20or%20xltm%20files%20in%20my%20PC%20(in%20various%20locations%3A%20root%20office%2016%20%26amp%3B%2015%20in%20%22program%20files%22%20and%20the%20custom%20files%20in%20the%20user%20app%20data%20and%20what%20have%20you...)%3C%2FP%3E%3CP%3Ebut%20it%20simply%20ignores%20all%20these%20possible%20templates%20and%20starts%20the%20new%20book%20with%20characteristics%20apparenty%20immutable%20and%20mysterious.%3C%2FP%3E%3CP%3EHow%20can%20I%20access%20those%20%22non-template%22%20parameters%20and%20change%20them%3F%20I'm%20sure%20I'm%20missing%20something%2C%20thanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-361955%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-362427%22%20slang%3D%22en-US%22%3ERe%3A%20using%20custom%20template%20when%20starting%20a%20new%20book%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-362427%22%20slang%3D%22en-US%22%3EYou%20can%20create%20your%20default%20workbook%20and%20worksheet%20by%20following%20the%20procedures%20in%20this%20link%3A%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fwww.mrexcel.com%2Fexcel-tips%2Fexcel-2019-use-default-settings-for-all-future-workbooks%2F%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.mrexcel.com%2Fexcel-tips%2Fexcel-2019-use-default-settings-for-all-future-workbooks%2F%3C%2FA%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I know how to create a custom template or, in general, how to force excel to start from a custom template. So that works when you double click to start Excel; I can get it to start with my preferred fonts, color palette, and so on. Nice.

What I don't know is: once the Excel program  is up and running and you want to open a new book from scratch >> select "File" then "new book", then Excel opens a fresh new book indeed, but NOT FROM THE SAME TEMPLATE IT HAD STARTED IN THE FIRST PLace or for that matter any template available.

I have previously checked all possible *.xltx or xltm files in my PC (in various locations: root office 16 & 15 in "program files" and the custom files in the user app data and what have you...)

but it simply ignores all these possible templates and starts the new book with characteristics apparenty immutable and mysterious.

How can I access those "non-template" parameters and change them? I'm sure I'm missing something, thanks in advance.

 

 

1 Reply
Highlighted
You can create your default workbook and worksheet by following the procedures in this link:
https://www.mrexcel.com/excel-tips/excel-2019-use-default-settings-for-all-future-workbooks/