Logo 
Search:

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: 1267
  

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
source.

Share: 

 

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.




Tagged: