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
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

23 additional answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2018-04-09T17:35:15+00:00

    Thank you for confirming. I have updated the team with this information and will let you know once I have more for you.

    -Jesse

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-04-09T16:33:31+00:00

    You can see where the templates are saved. 

    Here is the basic dialogue box. There is no button for personal or featured templates.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-04-09T16:31:31+00:00

    That is where I save my templates and it does not rectify the issue.

    Was this answer helpful?

    0 comments
  4. Jim G 134K Reputation points MVP
    2018-04-09T16:24:22+00:00

    Hi

    In order for a template to show in the gallery, these conditions must be met:

    1. Excel is up to date. You have 16.12, which is the current version so this is met
    2. The template file must be saved as a template using .xltx file type in the file format pop-up
    3. The template must be saved to the Templates folder (it won't work anywhere else)

    Here is a screen shot showing how the Save As dialog should look when you save your template. I clicked on the folder so you can see the file path of the Templates folder:

    Was this answer helpful?

    0 comments