ExcelDarkThemeFix

 

 

ExcelDarkThemeFix

Fixes Microsoft Excel appearance when custom Windows theme is used.

When the custom dark Windows theme is used, sheets, graphics items, charts and everything that have an “Automatic color” are displayed, exported and printed in the wrong colors.

This happens because Excel picks system colors (instead of using predefined ones) for the “Automatic color” which are altered by the themes.

This Add-In aims to fix this issue by setting colors to normal.

If you find this Add-In useful, you also might want to get PowerPointDarkThemeFix.

What is fixed?

1. Sheets
2. Cells
3. Graphic shapes
4. Charts – except slightly different font colors
5. Styles
6. Fixing multiple files in one click

What has workaround?

1. Charts’ font colors – there’s an option to set it to black.
2. Cell’s dark background when editing – there’s an option to fix it, but you won’t be able to undo anything. As an alternative, use the formula thingy right above the sheet to see what you type.
3. Different cells’ fill outside of used range – fill can be either preserved (including an actual automatic color, default behavior) or removed completely. There’s an option to tweak it.
4. OLE Excel objects – you need to manually open it, save and close.

Enabling configurable options is described under the Configuration section.

What is not fixed?

1. Colors may still be wrong – some Excel version will change colors to an arbitrary indexed colors depending on a theme. Not all colors and themes are affected.
2. SmartArt – as far as I’ve tried, unfixable.
3. Automatic color replacement – will make things undoable and heavily slow down Excel (if not make it unusable).
4. Table styles – impossible to fix built-in styles. Cells with custom styles are being fixed automatically without any issues.
5. Altering backgrounds – using background is a part of the fix. There’s no way of detecting whether the sheet has a background, so Add-In just will replace it.
6. Protected sheets – need to manually unprotect it, click “Fix all” button and, if needed, protect it again.
7. Possibly, some of Shape.Types.
8. You name it, I’m not an Excel expert :D

If you know how to fix any of these things, please, fill out an issue and describe a solution. I will greatly appreciate your effort!

Compatibility list

Fully compatible with Microsoft Office 2016, 2019 and 2021 (starting from build 14430.20306).

Reportedly, doesn’t fully work in 365, requires installation using “hard way” instructions and has to be put in a localized “AddIns” folder.

If you can test it with Office versions other than listed above, please, fill out an issue and I’ll update this list.

Installation

For download, visit project’s GitHub page.

Basically, you just need to install an Add-In. You can either stick to the instructions below or google a better guide.

Easy way

Warning: this method uses XLSTART folder which appears to be working fine, but it’s not an exactly correct way to install Add-Ins.

1. Download ExcelDarkThemeFix.xlam file and ExcelDarkThemeFixBG folder.
2. Navigate to %AppData%\Microsoft\Excel\XLSTART and put both ExcelDarkThemeFix.xlam and ExcelDarkThemeFixBG here. Do NOT move anything from ExcelDarkThemeFixBG and don’t rename it!
3. Open Excel and enjoy the Add-In.

If this method didn’t work for you, please, create an issue and try method below.

Hard way

This is more correct way to install an Add-In, but it’s hard to follow.

1. Download ExcelDarkThemeFix.xlam file and ExcelDarkThemeFixBG folder.
2. “Unblock” Add-In:
   1. Move the cursor over ExcelDarkThemeFix.xlam, click right mouse button and click “Properties”.
   2. At the bottom of the window find “Unblock” checkbox and check it. Then click “OK”.
   3. If you don’t have this checkbox, please, proceed to the rest of the steps.
3. Navigate to %AppData%\Microsoft\AddIns and put both ExcelDarkThemeFix.xlam and ExcelDarkThemeFixBG here. Do NOT move anything from ExcelDarkThemeFixBG and don’t rename it!
4. Enable macros:
   1. Open Excel.
   2. Navigate to “Options”.
   3. On the left side of the window click “Customize Ribbon”.
   4. On the right side of the window check “Developer” and “Add-Ins” boxes.
   5. Click “OK” and restart Excel.
5. Enable this Add-In:
   1. Open “Developer” tab.
   2. Click on “Excel Add-Ins”.
   3. Check the “ExcelDarkThemeFix” box.
   4. Click “Ok” and restart Excel.
6. If Add-In doesn’t work:
   1. If you have an antivirus:
      1. Add ExcelDarkThemeFix.xlam to the exceptions. Some antiviruses might prevent Add-Ins from running. Don’t worry, this Add-In won’t make you computer explode :p Check the sources if you’re unsure.
      2. Restart Excel and see if Add-In now works. If yes, you’ve installed Add-In, don’t follow the steps below.
   2. Navigate to “Options”.
   3. On the left side of the window click “Trust Center”.
   4. Click “Trust Center Settings…”
   5. Now you’ve got three options, try one after another:
      1. Unblock from PowerShell:
         1. Open PowerShell.
         2. Type Unblock-File -Path “AppData\Roaming\Microsoft\AddIns\ExcelDarkThemeFix.xlam” and hit Enter.
         3. Close PowerShell.
      2. Trust only installed Add-Ins:
         1. On the left side of the Trust Center window click “Trusted Locations”.
         2. Click “Add Location”.
         3. Click “Browse…”
         4. Navigate to %AppData%\Microsoft\AddIns (find a localized “AddIns” folder for non-English Office 365 verison) and click “OK”.
         5. Click “OK” in all opened Excel windows.
      3. Trust EVERY Add-In you open:
         1. On the left side of the Trust Center window click “File Block Settings”.
         2. Find “Excel 2007 and later Add-In files” row and uncheck both of the checkboxes. Well, you may uncheck all the rows to make your life easier.
         3. Click “OK” in all opened Excel windows.
   6. Restart Excel.

Edge case: If you’ve just installed MS Office and haven’t rebooted, install ExcelDarkThemeFix and reboot your PC.

Usage

Add-In does everything automatically. However, if you’ve set automatic colors to something and don’t want to fix it yourself, in Excel:

1. Open “Add-Ins” tab (if you didn’t have it, it has been added automatically).
2. Click “Fix all open workbooks”.
3. Read text in pop-up dialog. It says that if you click “Yes”, you won’t be able to undo the changes you’ve made. The only way to undo something is to close all workbooks without saving and open them again.
4. Click “Yes” if you will not need to undo anything.

Configuration

This Add-In provides some cool but unsafe options that you can enable. In order to do this, in Excel:

1. Open “Developer” tab.
2. Click on “Visual Basic”.
3. On the left pane, navigate to element displayed on the following screenshot and double-click on it:

 

 

You’ll see some code. Don’t freak out, just follow the instructions in it. Read everything carefully!

When you’re done, press Ctrl+S and restart Excel.