Make sure your template is saved in the correct file format. Excel templates should be saved with the .xltx or .xltm extension. To save a file as a template, go to File > Save As and select Excel ...

Copying data from one worksheet to another within the same workbook file is also pretty common and easy, especially if you’re copying template structure and expressions. SEE: 30 Excel tips you ...

Launch Microsoft Excel and then press "Alt-F" to switch to the File tab. Select "Options" from the menu, and then select "Manual" from under Calculation Options on the Formulas tab.