Excel Type mismatch error when adding Pivot Table.

When creating a pivot table from an Excel ListObject, it is important to use the R1C1 format when passing the range information to Excel's PivotCaches.Add method. Failure to do so will cause the method call to fail with the message "Type Mismatch" when the number of rows exceeds 65,536.