Excel - How to save custom table styles 2

[MattGreer]

I created a new table style and saved the file as book.xltx in AppData\Roaming\Microsoft\Excel\XLSTART

When I start Excel with a blank workbook, the custom style doesn't show up.

I put a copy of the file in \Documents\Custom Office Templates also.

Are we not able to save custom table styles with the default workbook?


Thanks!!


Matt

 

[Livia8]

If I'm not mistaken, the programme launches the "standard" format. However, if you go to File --> Open, you should see the option to open a new file on the basis of the template.

 

[MattGreer]

You are correct. I have to actually go open the template, manually. So it seems that one is unable to set a custom template as the default template in Excel. Unless I'm mistaken? Is there a workaround?

Thanks!!


Matt

 

[mintjulep]

You can change the default Excel template. Some possibly outdated instructions here

https://www.extendoffice.com/documents/excel/2403-excel-change-default-template.html

However, probably you should not. Because MS's tendency is to blow away modified versions of standard defaults during updates and repairs.

If you save something custom in a MS default template you risk losing it.

 

[MattGreer]

mintjulep,

Thank you for that information! I'll be sure to save a backup copy.

Thanks!!


Matt