excel数据透视表_Excel数据透视表故障排除

excel数据透视表

If you have a big Excel file, with lots of pivot tables and their source data, I've written a macro that might help you. The macros creates a detailed list of all the pivot tables in the workbook, so it's useful for documentation, and some types of troubleshooting.

如果您有一个很大的Excel文件，其中包含大量数据透视表及其源数据，那么我编写的宏可能会为您提供帮助。 宏会创建工作簿中所有数据透视表的详细列表，因此对于文档和某些类型的故障排除很有用。

宏列表数据透视表详细信息 (Macro Lists Pivot Table Details)

Here's a screen shot of the first few columns in the pivot table details list that the macro creates.

这是宏创建的数据透视表详细信息列表中前几列的屏幕截图。

It lists the sheet name, how many pivot tables are on the sheet, the pivot table names, and a hyperlinked range, where the pivot table is located.

它列出了工作表名称，工作表上有多少个数据透视表，数据透视表名称以及数据透视表所在的超链接范围。

Columns E and F show if there are other pivot tables in the same columns or rows. If the pivot tables are too close together, you could end up with overlap error messages.

E和F列显示在相同的列或行中是否还有其他数据透视表。 如果数据透视表之间的距离太近，则可能会出现重叠错误消息。

源数据信息 (Source Data Information)

For pivot tables that are based on Excel worksheet data (not in the Data Model), the list shows information about the source data too.

对于基于Excel工作表数据(不在数据模型中)的数据透视表，该列表也显示有关源数据的信息。

You can see the number of records, the column count in the source data, and the count of heading cells that contain