plsql数据表重命名
When you double-click a pivot table value cell, Excel adds a new sheet to your workbook, with the details for that summary value. To make it easy to find those sheets, and delete them later, use the latest version of my macros to rename Pivot Table DrillDown sheets.
当您双击数据透视表值单元格时，Excel将向您的工作簿添加一个新工作表，其中包含该摘要值的详细信息。 为了便于查找这些工作表并在以后将其删除，请使用最新版本的宏来重命名数据透视表明细表。
(Show Details Command)
Another way to create a DrillDown sheet is to right-click a pivot table value cell, and click the Show Detail commands.
创建DrillDown工作表的另一种方法是右键单击数据透视表值单元格，然后单击“显示详细信息”命令。
(Turn On or Off)
There is a setting in PivotTable options, on the Data tab, where you can turn off this feature, if you don't want people to use it.
如果您不希望人们使用此功能，则在“数据”选项卡上的“数据透视表”选项中有一个设置，您可以在其中关闭此功能。
In this screen shot, I've removed the check mark, so a message will appear if anyone double-clicks a value cell.
在此屏幕快照中，我删除了复选标记，因此如果有人双击值单元格，则会出现一条消息。
(Show Details or Drilldown)
If you record a macro while you change that setting, you'll see that Excel calls the feature Drilldown in the background.
如果在更改该设置的同时录制宏，则会看到Excel在后台调用功能Drilldown。
That's why I call these the DrillDown macros. And I capitalize the second D, just so it matches my initials!
这就是为什么我将这些称为DrillDown宏。 我将第二个D大写，恰好与我的名字首字母匹配！
(DrillDown Macros – Old)
Long ago, I posted a set of DrillDown macros, to help manage the details sheets. Instead of leaving Excel's default names for the sheets, the macro adds a prefix, "XShow_" at the start of the name.
很久以前，我发布了一组DrillDown宏，以帮助管理详细信息表。 宏没有在工作表中保留Excel的默认名称，而是在名称的开头添加了前缀“ XShow_”。
That makes it easy to find the sheets, and there is another macro that deletes all the sheets that have a name with that prefix.
这样可以很容易地找到工作表，并且还有另一个宏可以删除所有具有该前缀名称的工作表。
(Updated Macros)
Last week, Rich E. asked a few questions about the old DrillDown macros, and that inspired me to take another look at them.
上周，Rich E.问了一些有关旧的DrillDown宏的问题，这启发了我重新审视它们。
- For the macro that names each sheet, Rich asked if the prefix could be different, and if the tab colour could be set.
- For the Delete sheets macro, Rich asked about saving some or all of the sheets, when closing the workbook.
Those were great questions, and I created a new download file, with custom settings for the DrillDown macros.
这些是个好问题，我创建了一个新的下载文件，并为DrillDown宏设置了自定义设置。
(DrillDown Macro Settings)
Here are the custom setting cells on the sample file's Admin sheet
这是示例文件的管理表上的自定义设置单元格
When a new drilldown sheet is created, the macro changes its name:
创建新的明细表后，宏将更改其名称：
- The new name starts with the prefix from cell C4.
- Next is the number from C12, formatted as 3-digits.
- It ends with the name of the pivot table that was double-clicked.
NOTE: The first 31 characters of that string are used as the new sheet name.
注意：该字符串的前31个字符用作新的工作表名称。
(Other Options)
The Admin sheet has a tab colour cell too, and the fill colour from that is used on the new sheet's tab.
管理员工作表中也有一个标签颜色单元格，并且新工作表标签上使用的填充颜色。
You can also choose a location for the new sheet – make it the first or last sheet, or leave it where it is (Do not move)
您还可以为新工作表选择一个位置-将其设为第一张或最后一张工作表，或将其保留在原位置(请勿移动)
The current setting is "Last", so the new sheet is the last tab in this workbook.
当前设置为“ Last”，因此新工作表是此工作簿中的最后一个选项卡。
(Macro to Delete the DrillDown Sheets)
There is a Workbook Close procedure in the sample file, and it will delete All, Some or None of the DrillDown sheets.
示例文件中有一个“工作簿关闭”过程，它将删除所有，部分或无“向下钻取”工作表。
- ALL – Each sheet with the designated prefix is deleted, and the Next Number is reset to 1
ALL –删除具有指定前缀的每个工作表，并将“下一个号码”重置为1 - None – The drilldown sheets are left as is, with nothing deleted.
无 -向下钻取表保留不变，不删除任何内容。 - Some – The macro shows a message for each sheet that has the designated prefix, and asks if you want to delete it. The Next Number is not reset.
某些 –宏会为每个具有指定前缀的工作表显示一条消息，并询问您是否要删除它。 下一个号码不会重置。
(DrillDown Sheet Info)
Another feature in the new DrillDown macro is the information added to the right of the detail table.
新的DrillDown宏的另一个功能是在明细表右侧添加的信息。
It shows the date that the sheet was created, the pivot table name and the pivot table's sheet name. The sheet name is hyperlinked, so you can get back there quickly.
它显示工作表的创建日期，数据透视表名称和数据透视表的工作表名称。 工作表名称是超链接的，因此您可以快速回到那里。
(Get the Sample File)
To see the macros to rename Pivot Table DrillDown sheets, go to the DrillDown page on my Contextures website.
若要查看重命名数据透视表“钻取”工作表的宏，请转到Contextures网站上的“钻取”页面 。
In the Download section, click the link for the Custom settings workbook (the second sample file.)
在“下载”部分中，单击“自定义设置”工作簿的链接(第二个示例文件。)
The zipped workbook is in xlsm format, and contains the macros. Be sure to enable macros, if you want to test them.
压缩的工作簿为xlsm格式，包含宏。 如果要测试宏，请确保启用它们。
翻译自: https://contexturesblog.com/archives/2018/09/13/rename-pivot-table-drilldown-sheets/
plsql数据表重命名
