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: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2018-03-07T21:49:11+00:00

    Could you try creating a copy of the template you recently made and saving it in the default location? Knowing whether this is specifically tied to the save location will help us investigate.

    -Jesse

    Was this answer helpful?

    0 comments
  2. Anonymous
    2018-03-08T14:03:56+00:00

    Well, another tricky question. I just checked in both Word and Excel. 

    WORD

    • The templates are stored in users/[username]/library/group containers/UBF8T346G9.Office/User Content/Templates.
    • I checked in Preferences for the template file locations, which also pointed to this folder.
    • If I go to the folder, I see my normal.dotm, normalemail.dotm, and two custom that I made (one for this test) (BTW, only Word templates are in this folder)
    • If I go to File/New From Template, none of the custom templates show up.

    EXCEL

    • In Microsoft's infinite wisdom, the Preferences for Excel and Word are wildly different. Excel does not have a "folder location" tab. Thanks, guys. Well done, again.
    • If I search for Excel templates in finder, I only find the two I created yesterday, which are in a folder I also created yesterday in "Documents." I cannot find any other templates by name or type. They have to be somewhere!
    • So, I don't know the answer to your question. I can't find the default location.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2018-03-08T19:11:10+00:00

    That's good information, thank you for checking. I'll pass this information along to the teams.

    -Jesse

    Was this answer helpful?

    0 comments
  4. Anonymous
    2018-03-08T20:25:15+00:00

    Can you double check something for me? When you go to the "New from Template" screen, do you see two buttons at the top that say "Featured" and "Personal"? It should look like this.

    When you select "Personal" it should show you your custom templates. If that isn't there, let me know as that would be a bug.

    -Jesse

    Was this answer helpful?

    0 comments