You have not specified any source ranges for your PivotTable.Type or select at least one range in the Ranges box before choosing ...