New custom cell styles not saving and not available in new workbooks

BrendonDavies565 

I had the same problem and found this article helpful: Microsoft Excel: https://thesoftwarepro.com/customize-excel-workbook/.

Essentially, two locations have an XLSTART folder. One is in your user app settings and one in the program folder. To solve the issue, I did the following.

1. Saved my "book.xltx" in  C:\Users\<username>\AppData\Roaming\Microsoft\Excel\XLSTART\
2. Save another copy of my "book.xltx" in C:\Program Files\Microsoft Office\root\Office16\XLSTART\
3. I unchecked the setting "Show the Start screen when this application starts." The checkbox is at the bottom of the general tab in the Excel options.

If you don't want to turn off the start screen, you must press Ctrl-N to open a new workbook with your template.

I hope this helps!

Nick