parry
MrExcel MVP
- Joined
- Aug 20, 2002
- Messages
- 3,355
Hi, we have a spreadsheet where information is entered each month into Sheet2. A Pivot table is located on Sheet1 and I want to update the Pivot table with the new range thats in Sheet2.
It seems I need to use the SourceData propoerty of the PivotCache but I get a type mismatch error. Any clues?
It seems I need to use the SourceData propoerty of the PivotCache but I get a type mismatch error. Any clues?
Code:
Sheets(1).PivotTables(1).PivotCache.SourceData = Sheets(2).Range("A5:T40000")