title: Changing the Data Source of the Pivot table using macro in excel vba
body: <p>I am new to VBA and need to change the data source
  Need to update the pivot table in Sheet1 worksheet in columns ‘Y’, ‘Z’ and‘AA’.
  (With the analyse/Options tab of  Change Data Source)
  Select all data in column ‘Q’ to column ‘W’ Of Sheet1 itself!
  In short:- I need to change the data source of the pivot to 'Sheet1'!$Q$4:$W$1940. in column ‘Y’, ‘Z’ and‘AA’.</p>
  <p>Please help with a working code (of macro -vba), I have been searching on google but no luck!</p>
  <p>Thanks in advance!</p>