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

pivot table not updating even when I changed data source get the following message cant open pivotable source file

I have two separate pivot tables, with the same data source, I want to use a cell value to update filters for different pivot fields from this one cell value. I need to be able to do this same operation on the work sheet for 3 or 4 cells. Filter by Month then year and by customer name.

I have three different data sources that feed into three different pivot tables, and I need to create a button or drop down that filters all three tables by date at the same time.

Hi when I try and refresh my data input i receive a message saying Pivot Table field name is not valid when I try and change the data source it won't accept the whole range only 5 lines of it not 700! I am sorry I am not sure what you mean by the file?

Task Please combine both data sets into one tab, bring ‘multi color’s and ‘Goal Completions All’ to the Data Source 1 and add a pivot table to map keywords to URLs. Values for each URL should be: Count of ‘keywords’

my pivot table data source is only picking up first line. The column have the same value so its only picking up the first insead of giving me a sum of all the values that are the same

If I change the data source of a pivot table to include full columns, it changes the data source to a different tab.

Pivot table not picking up new source data. Data source already changed.

I created a pivot table linked to source data in a separate worksheet and the pivot table was distributed to employees. The data had confidential in it that was accidentally included. I thought deleting the sheet with the data source would break the pivot table, but that is not the case. Can I do anything to corrupt the pivot table?

I need a pivot table data source merged from three sheets within the same file. I want a master sheet that merges all data source