This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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]
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
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.
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.
That is a tricky question. Well, when the new Office dropped a month or so ago, it deleted all my templates. Nice of them.
But they likely were saved to default. I'm not exactly sure. I just, today, saved a new template to a folder I created in Documents.
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
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.
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