Get instant live Excel expert help and learn how to change the source data for a Pivot Table

Sir, I want to change the data source of my pivot table to another data source in another spreed sheet, how can I go about it in Google spreed sheet? Thanks

Hi, I use excel 2016. 1. When I use Pivot table, how can I hide drop down buttons and still keep the first row.(If I remove the check mart "display field captions and filter drop downs", the first line also was hided). I want to keep the first heading and hide the buttons. 2. How can I choose the several different columns from data sources using Pivot Table. Each time when I select all items in rows, it always put under one by one. I want to it show in different columns in the pivot table.

i need my control sheet to have formulas so that the data amount can be automatically transfered to the Pivot Table, i also need a new Pivot table as the one i have i need to delete and start over with new data source

I need the Pivot Table Wizard in Excel from Office Home and Student 2016 for Mac. The Cmd-Opt-P that works in Excel 2011 for Mac won't work in the 2016 version. I need to add ranges. The Change Data Source doesn't work: it says because I have dat "from multiple consolidation ranges" and it says to use "Command + Option + P" which doesn't work. Is there another way of bringing up the Pivot Table Wizard?

I have a line chart created with 3 series (data sources) total, from 3 pivot tables. I also have 3 filters for each pivot table (the same filter for each table). My issue is that my date ranges on tables #2 & #3 are not showing blank data and keeping the date list the same when I filter the pivot tables. I have selected the Pivot table Display Option to 'Display item labels when no fields are in the values area' and it is doing that for the first pivot table, not for the others. The setting is greyed out for tables #2 & #3 and still checked (although not displayed).

Hello, I am having problems with PowerPivot and changing data sources. The pivot tables are disappearing and not able to update data source.

Sheet EXERCISE 5 1. Fill In Empty Fields * Day in"ddd" format *Week should start from Monday *Month in "mmm" format *Country using excel Mapping table 2.Apply Pivot Table using Table 1 as Data source *Reflect in Pivot how many records per country Met 4Hr TAT *Reflect in Pivot how many records per country Out of 4Hr TAT *Reflect in Pivot Total Amount of records *Reflect in Pivot % of records Met 4 HR TAT

I'm trying to create a pivot table from an external data source I copied into excel, however the important columns, "Address" and "Name", I need to analyze has a 'merged cells' error for some reason and is not letting me pull it into the pivot table. The cells don't appear merged and I have highlighted them to unmerge them without any success. I'm beyond frustrated, so any help you can provide would be great!

2.Apply Pivot Table using Table 1 as Data source *Reflect in Pivot how many records per country Met 4Hr TAT *Reflect in Pivot how many records per country Out of 4Hr TAT *Reflect in Pivot Total Amount of records *Reflect in Pivot % of records Met 4 HR TAT Apply Slicers to sort by Month/Week/Day/Country *Fix Slicers (should not move in the case of changing cells size) Apply Pivot chart reflecting MET TAT/Out of TAT/Total Volumes vs TAT%

I have two data sources that I need to merge into one in PowerPivot, but the naming conventions of each set don't match exactly. How can I merge these two so that my pivot table sums are what i need them to be?