You are here Excel lost Theme. How to recover it - Excel mất Theme

Query, Share and Manage Excel workbooks on LAN, Internet

Excel lost Theme. How to recover it

1. How to know your Microsoft Excel lost Theme?

- When opening the Microsoft Excel, you get the error message "This control requires version 4.70 or greater of COMCTL32.DLL"

alt

OR:

- When you open a dialog/window, you see the color or style of the button, Edit, ListView,... is classic like the screen below:

alt

(Button is classic style)

alt

(ListView lost group feature)

2. How to restore Theme in Excel

(*) As long as you have installed Add-in A-Tools from v9.1.0.8 or BSAC.ocx from v2.0.0.8, you can follow the steps below:

1. Right click on the Excel icon
2. Run as administrator
3. Quit Excel and open it again

alt

 

Now you open Microsoft Excel again, you can see the dialog box with all the controls is great.

- ListView has grouping feature
- All controls are nice...This screen is not cool. You can not see ListView with grouped items

...

alt

alt