Excel suppresses compilation error in module: Format table

When your Excel table appears with this error dialog box:

When Excel suppresses compilation errors in a module: table-style, it may be caused by the following reasons.

First, the wrong macro code

A macro may be referenced in the table, either because the macro code is wrong, or if the macro does not exist at all, or if the module referenced in the macro code does not exist.

In this case, the best way is to remove the macros.

The method is simple: Press the key combination Alt + F11 into the VBA window, find the ThisWorkbook, then look down, you can find the code, and then delete.

Second, reset the system account

The most troubling thing about this is that reinstalling Office is not going to help, no matter how it is, it is the original mistake.

The most effective solution is to reset an account to the system and use that account to log on to the system and use the Excel file normally.

Iii. Alternative Solutions

① restore Excel to default state

1, delete the C:Program filesmicrosoft Officeoffice11xlstart directory of macro files (can be backed up first)

(OFFICE11 is a OFFICE2003 directory)

2, if 1 is invalid, delete the Excel item under the registry Hkey_current_usersoftwaremicrosoftoffice, and the Excel item under 11.0, after reopening, Excel will revert to the state of the new clothes.

② let Excel automatically restore default state

If you can open Excel normally, open Excel first, select "Detect and Restore" in Help, and click "Start" to be able to recover.