My custom templates never show up in the "New From Template" view in Excel 2016 Mac.

Anonymous
2018-03-07T15:07:42+00:00

This is very frustrating. Overall, I really dislike the new Excel (16.12). It just screws up the simplest things, including my templates. Same for Word, by the way. All my custom stuff disappeared. 

In this case, I create a template and save as template. But unless I go find that file again, it never appears in the "New From TEmplate" view. And when I open that created template, it just opens as a template file, not as a document from a template. It is like the template format is completely useless. 

I want to select New From Template and see all my custom templates and open them. This will help me get around the bullcrap issue of excel opening too small on a 27" iMac. 

Any thoughts? From a frustrated Office for Mac expert user. 

[The thread has been moved to the correct category by forum moderator]

Microsoft 365 Insider | Excel | MacOS

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
Anonymous
2018-04-09T19:09:13+00:00

It normally will create a new document using the name of the template, and appending it with a document number.  So, if your template is called "Scott TEST.xltx", it would create "Scott TEST1".  It would only create "Book1" if the template is called "Book.xltx" or if the default blank workbook template is used.

Was this answer helpful?

0 comments No comments

23 additional answers

Sort by: Newest
  1. Anonymous
    2018-03-07T18:32:33+00:00

    Thanks for the information. One last thing - where are you saving your templates? In the default location, or somewhere else? Also, are your templates all saved in the same place?

    -Jesse

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2018-03-07T17:33:26+00:00

    16.12 (180305). 

    Yes, the same in Word. Same thing in PPT. I create and save a template. Then it doesn't show up in templates. Huh? Kinda the purpose.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2018-03-07T17:22:47+00:00

    Hi Watson,

    Can you let us know the full version and build you are running? You can find that information by going to Excel > About Excel and looking for the number that looks like "16.x (xxxxxx)." Also you mentioned that you are having the same problem in Word as well as Excel? Is that correct? Are you able to see if the same is happening for you in PowerPoint as well?

    -Jesse

    Was this answer helpful?

    0 comments No comments