Question

What are the advantages and disadvantages of saving a workbook template to a folder other than the Templates folder?

Answer 1

DISADVANTAGES OF SAVING A WORKBOOK TEMPLATE TO A FOLDER OTHER THAN THE TEMPLATE FOLDER :-

• If you might need to save a workbook in another file format of an earlier version of Excel,a text file or a XPS file.or whenever you save a workbook in any other folder or format ,some of its formatting,data,and features might not be saved.
• you cannot create a new workbook that are consistent and can help you to customize your work for specific tasks.

ADVANTAGES OF SAVING A WORKBOOK TEMPLATE TO A FOLDER OTHER THAN THE TEMPLATE FOLDER :-

• Templates works everywhere in word processors,spreadsheets,survey platforms,emails and management apps .
• There are several places where you can use templates much more efficiently and faster.
• Any files saved in other folder like powerpoint (or any subfolder) will be automatically displayed in the correct application.For example you can could create a subfolder called guiding Solutions which contains all the templates for Excel, Word and PowerPoint.The tab is only displayed in Excel if there are files in this folder with the following file extensions (.xls, .xlsx, .xlt, xltx).