Excel Error while updating an external data source into a pivot table!

Joined
Sep 19, 2017
Messages
1
Reaction score
0
I am trying to update the data source of a Pivot table in a worksheet using the below code. I am not very sure what could be the miss here, but I am getting a "Run-time error 5 - Invalid Procedure call or argument" error. Can somebody please help me on this... Thanks in Advance!


Sub PivotSource()
Application.EnableEvents = False

Worksheets("Pivots").Select
ActiveSheet.PivotTables("Pivots_1).ChangePivotCache ActiveWorkbook. _
PivotCaches.Create(SourceType:=xlDatabase, _
SourceData:=("C:\Users\testuser\Documents\My Received Files\[test file - Copy.xlsm]MasterSheet!Master_Range"), Version:=xlPivotTableVersion14)

Application.EnableEvents = True
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top