How to solve the book1 virus in Excel

Then all the opened Excel files in the local area will be infected with the virus, and the files uploaded to each other in the LAN will eventually be infected by this macro virus file on many colleagues' computers. Book1 is displayed when you open any Excel file.
After some searches and experiments, the more reliable solution is as follows: 1) Check the Directory: (take XP as an example) c: \ Documents and Settings \ <user> \ Application Data \ Microsoft \ Excel \ XLSTARTc: \ Documents and Settings \ <user> \ Application Data \ Microsoft \ Excel \ c: \ Program Files \ Microsoft Office \ OFFICE11 \ STARTUP c: \ Program Files \ Microsoft Office \ OFFICE11 \ XLSTART clear the Files (not folders) in the above three folders, "USER" indicates the User name used. If it is Windows 7, the corresponding directory is in the USER. If it cannot be found, you can use the system search function to find STARTUP and XLSTART. 2) Check Excel tools/options/General/open all files in this directory at startup. If yes, clear the files. 3) format-> worksheet-> unhide, then you will see: XL4Test5 worksheet 4) This step does not make any sense (only for technical discussion), directly Delete this table (XL4Test5) that's it! Menu: Tools-> Protection-> undo worksheet protection to view 35th rows, or the format is as follows: = PROTECT. DOCUMENT (TRUE, "R97", TRUE) Code. In this example, the password is R97. 5) after deletion, a message is displayed, indicating a reference error: insert-> name-> definition, delete all unused names. 6) Copy Excel11.xlb from other normal computer directories C: \ Documents and Settings \ <user> \ Application Data \ Microsoft \ Excel to overwrite files with the same name on the local computer.