Get instant live Excel expert help and learn how to refresh Pivot Tables automatically

“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

Hi, when I refresh my pivot table it changes the format. It use to not do that. What can i do?
Solved by O. J. in 18 mins
Hi, I'm looking to create a from by typing in the reg and it pulling through the data from the data tab. I've tried this as a VLookup but it only pulls through the first line and there may be more than one line under each reg for repair history. I tried doing this as a pivot table, but I don't like the layout of it and wanted to be able to type in a reg and it search for the data rather than filtering. I've tried a combination of both by creating a macro to copy the data from cell A1, refresh the data in the pivot table, filtering by pasting the results from A1 then copying the relevant data I require onto the form tab. It works, but when I change the reg it remembers the actual reg text from the macro rather than the act of copying and pasting the data in A1 from the form. Can you help me please?
Solved by B. J. in 13 mins
Hi - I am trying to fix a problem in a budget spreadsheet I created. I have a tab where all my master data is stored (hundreds of line items with different columns for categories, locations, etc.). I have created pivot tables to show comparisons of those categories, but then I'm also trying to do an overall budget view on one tab. I had linked the cells back to the pivot table charts, but when I refresh the pivot tables, my data in the overall chart doesn't update. So, how do I summarize 200 lines of data into multiple categories in one table with the sum of the budget items for each?
Solved by I. B. in 27 mins
I have a pivot table that contains multiple values, 0 to 10, I need to do an NPS calculation on this data, so sum all 9's+10's minus all (0+1+2+3+4+5+6's) divided by the total. =((SUM(GETPIVOTDATA("NPS Score",$A$4,"NPS Score",{9,10})))-(SUM(GETPIVOTDATA("NPS Score",$A$4,"NPS Score",{0,1,2,3,4,5,6}))))/GETPIVOTDATA("NPS Score",$A$4) I can do this when all the references exist, however I need to refresh the pivot weekly, so not all the values will appear every week. Is there a way for my formula to work if the reference doesn't work?
Solved by S. J. in 11 mins
I need help with sheet two on my weekly numbers spreadsheet. The pivot table is working perfectly you guys built for me when I hit the refresh button but the numbers are not adding correctly in row F to match what I need in those specific fields. Can you help with this?
Solved by D. L. in 13 mins
I need help with pivot table template. I am sending a template I found in Excel 2016. Issue I'm having is in regards to a pivot table on the "pipeline calculations" tab. When I make any changes to the "pipeline input" tab and then go to the "pipeline calculations" tab to click refresh (right click) and update the data, I get an error (#name?) throughout every cell in the pivot table. I cannot figure out why it keeps doing this.
Solved by A. F. in 11 mins