Excel2010 no script Editor to bulk modify table names

EXCEL2010 does add and improve a lot of features, but it also reduces some of the functionality, such as the Microsoft Script Editor in Version 2003. As a result, operations on the bottom of Excel have become difficult. As an example of changing the worksheet name in bulk, Excel2003 can modify it directly in the Script editor without closing the workbook.
As shown in Figure 1, the workbook BOOK1 a total of six worksheets, and now you need to add a "month" word after each worksheet name.

Actions in Excel 2003

Click on the "tools → macros →microsoft Script Editor" to open the Script Editor, the default display of the worksheet "1" script, click "View-Project Explorer", double-click the "BOOK1" tab in the Project Explorer, display the workbook script. Click "edit → find and replace → replace" to find the content "", replace with "month", and replace all (Figure 2).

Instead of closing the Script editor, back to the Excel interface, a Refresh dialog box appears, clicking the Refresh button and the worksheet name is changed in bulk (Figure 3).

Actions in Excel 2010

In the new version of Excel, the same worksheet name changes in bulk, first to change the name of Worksheet "1" to "January" after saving and closing the workbook. Because if you do not have Chinese in all of the worksheet names in the workbook, Excel will make an error if you follow the previous procedure.

We have a solution, "right-click workbook → open mode →winrar compressed File Manager", double-click the XL folder, locate the Workbook.xml file, and open it in Notepad.

Select edit → replace, enter "sheetID" in the lookup, replace with "month sheetID", replace all, close Notepad, click "Yes" in the two dialog boxes that appear, and save the file (note: It is still case-sensitive when looking for replacements).

Reopen the workbook, and the worksheet name has been changed in batches.

Changing the name of a worksheet, bulk adding, modifying hyperlinks, bulk Inserting, modifying annotations, and so on can be done using the above methods, and the loss of the Script Editor Excel 2010 can only be resolved when the workbook is closed.