Excel2010 Bulk Modify table name without Script Editor

First taste Excel2010, its gorgeous interface, perfect function, convenient operation is really fascinating, but the new version of Excel in the function is not increasing. Perhaps because of the frequency of use, Microsoft has canceled some features. such as the Microsoft Script Editor, Version 2003.

But from the author's experience, this is a great loss, so many of the operations directly on the bottom of Excel become more difficult to implement. 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.