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.
Hi - While we work to figure out what could be happening on your computer, there is a workaround that you can use to avoid opening the files as templates. If you go to the folder using Finder, and then double-click on a template file, it should open as a new document based on that template. For example, I have an Excel file called "My Blank workbook.XLTX" and when I double-click on it in Finder, it creates a new document called "My Blank Workbook1".
You mentioned that the previous templates that you had already created were lost when you upgraded to a recent version of Office. This is definitely unexpected, since the installation should not remove existing content. I think it's worth using Finder to search for the files by name, if you haven't done so already.
Back to the issue of the "Featured" and "Personal" tabs not showing in the "new from template" panel, please send feedback to us about this issue using the smiley-face button near the top right corner of the Excel window. If you include your email address in the feedback, I will look it and contact you to work through the issue.
One thing to try in the meantime is to make sure you have the apps closed the next time you get an update. The update tool should verify the apps are not running while they're being updated, but I have seen a few times when the installation proceeded anyway, and it could result in some files not getting updated properly. It seems like you'd be having other problems if that were the case, but it can't hurt to try. Maybe you've already uninstalled/reinstalled, which should have avoided an update issue such as this.
Thanks - Steve K [MS Excel]
BTW - it looks like you attached screen shots to an earlier comment on this thread, but I'm not able to see them for some reason.
Thank you for confirming. I have updated the team with this information and will let you know once I have more for you.
-Jesse
You can see where the templates are saved.
Here is the basic dialogue box. There is no button for personal or featured templates.
That is where I save my templates and it does not rectify the issue.