Excel suppresses compilation error in module: Format table

Source: Internet
Author: User
Tags reset

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.

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.