An exception of type ArgumentException will be thrown if: - A
null reference is passed in as a parameter instead of a valid Area object - The new data source is not in the same workbook
- Not every cell in the first row of the new area contains a value for the column name
- The area for the new data source only has one row (PivotTables require at least two)
|