Excel pop-up Book1 virus solution

The roommate's computer opened a poisoned Excel file from a school teacher without a precaution. As soon as you open the Excel file will automatically pop up a Book1.xls, and the virus will continue to infect the next local all open Excel files, plus the local network of mutual transmission files eventually many colleagues of the computer is this contains a macro virus file infection.

Opening any Excel file will pop up Book1

Seriously affect normal work

After a search and experiment, the more reliable solution is as follows:

1) Check directory: (XP system for example)

C:documents and Settingsapplication Datamicrosoftexcelxlstart

C:documents and Settingsapplication Datamicrosoftexcel

C:Program FilesMicrosoft Officeoffice11startup

C:Program FilesMicrosoft Officeoffice11xlstart

The files in the above 3 folders (not folders) empty, "User" represents the user name used, if it is Win7 system then the corresponding directory in user, can not find the system search function to find startup, XLSTART.

2 and check Excel Tools/Options/General/Startup when opening all files in this directory, if available, empty.

3) Format-> sheet-> Unhide, you will see: XL4TEST5 worksheet

4 This step does not make any sense (only to do technical discussion), directly delete this table (XL4TEST5) on it!

Menu: Tool-> protection-> Undo Worksheet protection

Look at line 35th, or form like =protect. Code for DOCUMENT (True,,, R97, true), this example protects the password as: R97

5 After the deletion will be prompted to say what reference error:

Insert the-> name-> definition, and then delete any names that are not used.

6 from other normal computer directory c:documents and settingsapplication datamicrosoftexcel copy excel11.xlb overwrite the same name file can be completely repaired.