数据透视表 数据源引用无效_数据透视表源数据文章

数据透视表 数据源引用无效

The key to success with Excel pivot tables is having good source data. I've written many articles with pivot table data source tips, and this list will help you find the information that you need. Some of the articles are on my Contextures website, and others are on my Pivot Table blog.

Excel数据透视表成功的关键是拥有良好的源数据。 我写了许多有关数据透视表数据源技巧的文章，该列表将帮助您找到所需的信息。 其中一些文章在我的Contextures网站上，其他文章在我的数据透视表博客上 。

设置源数据 (Set Up the Source Data)

No matter which version of Excel you're using, the source data needs to be in a well-organized list, that will grow or shrink as you add or remove data.

无论您使用的是哪个版本的Excel，源数据都必须位于组织良好的列表中，并且在添加或删除数据时，源数据会不断增长或收缩。

• In Excel 2007 and later, that list can be set up as a named table, which will expand automatically, as new data is added.

  在Excel 2007及更高版本中，该列表可以设置为命名表 ，随着添加新数据，该