Forum Discussion
Solved
New themes issues - actual default excel-template change to revert
Hi everybody. My first question in this group, so please excuse any posting errors (and advice how to do better next time). WINDOWS VERSION: 23H2 (Build SO 22631.2861) MICROSOFT 365 Apps for ent...
- I have the same problem, and I am pretty dismayed to see there is no answer to this. I have excel macros that work based on colour, and then after a copy and paste of data from a source file to a new file, all the colours change and everything gets screwed up as a result.
I am pretty unimpressed that changes like this just seem to happen and it seems the only place to try to get an answer is on a "community" page where someone may or may not answer you.
I can see you can change the theme back on a new file by going to "Page-Layout" and then re-select the Theme you want there, if your old one is there (for me I wanted "Office 2013 - 2022"), and that is fine to fix for the new file, but not something I want to have to do every time, I want to change it so the default is the one I want, not just the latest theme that someone in the Microsoft team thought might be nice!
I'm having the same issue - another work-around (in addition to the other response below) is to create a Custom Theme.
Set up your settings for a blank workbook with only one sheet with the way you want the default to look. Then go to Page Layout -> Themes -> Save Current Theme
(Do the same thing for "Colors" and "Fonts" and "Effects" if you desire)
Now at least your custom theme can be quickly applied to a new workbook by navigating to the same place, because now it will be at the top (as you can see with mine).