save changes to template excel

Question

I have created a template in excel and am constantly refining it.

How do I save the changes I have made without creating a new template every time.

Also it would be handy if the files i have used the template for could update to the new version with changes if i chose to do so.

Thanks

James.

Answer 1

Follow the steps and check if it helps.

1. Open a template and edit it.
2. Click on File -> Save as.
3. Choose Excel template in the Save as type.
4. Now select the exiting template shown in the save as type -> Click on Save.
5. You will get a prompt to replace the template -> Click on YES.

This will update the template in Excel.