In Word, documents are permanently connected to the template they were created from, and not everything in the template gets transferred to the document.
Templates behave slightly differently in Excel. The entire template becomes a new workbook with no connection back to the template.
You create Excel templates in exactly the same way as you create a Word template, simply save as a template file (.xltx or .xltm).
|