Pivot Table/Macro Error

Question

Hello everyone. I have an error when trying to run my marco to create the needed pivots. My current macro will condense the needed information but when it comes to the pivot steps, I get the following code:

Run-time error '5':

Invalid procedure call or arguement

When I try to debug the macro, this is what is highlighted for me:

ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _        "CORE Recon Refi!R1C1:R250C8", Version:=xlPivotTableVersion12). _        CreatePivotTable TableDestination:="Daily Summary!R5C4", TableName:= _        "PivotTable1", DefaultVersion:=xlPivotTableVersion12

I wouldn't care if I had to record another macro but I have 3 pivots I need to creat and I'm hoping that I won't have to debug everyday.

Thanks!

Answer 1

Issues related to Pivot table would be better addressed in the TechNet forums for ITPRO. Click on the link below to post your issue in TechNet.

http://social.technet.microsoft.com/Forums/en/excel/threads

Answer 2

Hi,

Although, already exist pivot tables on 'Daily Summary' (or not ?),

you want to add/create one more ?