MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Change data source for a pivot table

  Asked By: Anita    Date: Sep 30    Category: MS Office    Views: 1237

Can anyone tell me how to change the data source for a pivot table? I
know how to go and find the range I want and to return the value, but I
can't figure out how to tell the pivot table this is the new data



1 Answer Found

Answer #1    Answered By: Brent Brown     Answered On: Sep 30

Right click the pivot  table. Click on Wizard. Click Back. Set the new Range.

Didn't find what you were looking for? Find more on Change data source for a pivot table Or get search suggestion and latest updates.