Forum Discussion
JulienTheriault
Aug 03, 2022Brass Contributor
Full Dark Mode in Excel
Currently you can set Office Theme to Black which acts as a dark mode. In Word, setting this to Black makes the page dark and the text white when it is set to “Automatic”. I was wondering if anyo...
AdrianParker
Feb 09, 2023Brass Contributor
Don't know if it maters, but I'm running office 2019.. perhaps you're using a different version that needs different settings ?
It's worth checking your areas and filenames.. I don't know if the case of the filenames matter but I was careful to set them to Book.xltx and Sheet.xltx.. worth a check.
AdrianParker
Feb 09, 2023Brass Contributor
One other thing I've noticed that was annoying.. if you prefer to use the alphabetic columns instead of the R1C1 format, then you'll need to set that before saving the templates else it will always default to R1C1 format when you open excel.
- JKPieterseFeb 09, 2023Silver Contributor
AdrianParker You'll have to check all calculation settings as well, as they are also saved with the file.
The Sheet.xltx and Book.xltx names must be aligned with how your language version of Excel names a newly inserted workbook and worksheet. For Dutch Excel, the template names must be Map.xltx (or Map.xltm) and Blad.xltx respectively.