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

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

pivot table not updating even when I changed data source get the following message cant open pivotable source file
Solved by E. A. in 18 mins
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.
Solved by Z. B. in 28 mins
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.
Solved by F. S. in 27 mins
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?
Solved by A. C. in 24 mins
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’
Solved by A. Y. in 26 mins
my pivot table is only picking up first line of data from data source. 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
Solved by E. A. in 30 mins
If I change the data source of a pivot table to include full columns, it changes the data source to a different tab.
Solved by I. Q. in 22 mins
Pivot table not picking up new source data. Data source already changed.
Solved by D. B. in 24 mins
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?
Solved by I. J. in 16 mins
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
Solved by X. J. in 14 mins