All solutions PIVOT TABLERefresh Expert Solution – How to Refresh Pivot Tables

Excel - How to Refresh Pivot Tables - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Refresh not working for pivot table/chart. "This command requires at least two rows of source data. you cannot use the command on a selection of only one row. Try the following" If you're using an advanced filter, select a range of cell that contains at least two rows of data. then click the Advanced Filter command again. If you're creating a PivotTable report or PivotChart report , type a cell reference or select a range that includes at least two rows of data
Solved by F. H. in 25 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 22/08/2018 - 06:31
Hello
User 22/08/2018 - 06:31
Hi
Excelchat Expert 22/08/2018 - 06:31
How can i help you today?
Excelchat Expert 22/08/2018 - 06:32
I understand that you are trying to refresh the pivot
User 22/08/2018 - 06:32
[Uploaded an Excel file]
Excelchat Expert 22/08/2018 - 06:33
Can you forward me the working excel?
User 22/08/2018 - 06:33
this used to update as i added data
User 22/08/2018 - 06:33
[Uploaded an Excel file]
Excelchat Expert 22/08/2018 - 06:34
I have your excel.. tell me what you are trying to do
Excelchat Expert 22/08/2018 - 06:34
so that I follow it and can track the error
User 22/08/2018 - 06:35
using data from Account Sign Up v2 in a pivot table on Progress_chart
User 22/08/2018 - 06:35
as I update or input data on Account Sign Up v2 it should update the pivot table/chart on Progress_Chart
User 22/08/2018 - 06:36
i used to just hit refresh and it would update
User 22/08/2018 - 06:36
now get error
Excelchat Expert 22/08/2018 - 06:36
what data you are changing in account sign up v2
Excelchat Expert 22/08/2018 - 06:36
tell me cell the number and I will update and see whether it gives the error at my end as well
User 22/08/2018 - 06:36
case number column and Upgrade completed columun
Excelchat Expert 22/08/2018 - 06:37
ok
Excelchat Expert 22/08/2018 - 06:37
let me try
User 22/08/2018 - 06:37
i will a case number to the case number column.. so it goes from blank to a case number.. that should update the "customer engaged" line on chart
Excelchat Expert 22/08/2018 - 06:38
Stay tuned, I am looking at the solution for the error.
User 22/08/2018 - 06:38
if i change a no to yesin the upgrade complete it should change the bar graph on chart
Excelchat Expert 22/08/2018 - 06:38
ok
Excelchat Expert 22/08/2018 - 06:44
[Uploaded an Excel file]
Excelchat Expert 22/08/2018 - 06:44
See if the error is still coming up?
User 22/08/2018 - 06:45
ok
User 22/08/2018 - 06:47
yes
Excelchat Expert 22/08/2018 - 06:47
you getting the error?
Excelchat Expert 22/08/2018 - 06:47
its working fine at my end
User 22/08/2018 - 06:48
hhmm
User 22/08/2018 - 06:49
[Uploaded an Excel file]
Excelchat Expert 22/08/2018 - 06:50
[Uploaded an Excel file]
Excelchat Expert 22/08/2018 - 06:50
try this. it will work fine
User 22/08/2018 - 06:50
thats it
User 22/08/2018 - 06:50
all good now
Excelchat Expert 22/08/2018 - 06:50
:)
User 22/08/2018 - 06:50
what was issue?
User 22/08/2018 - 06:50
can u explain so i can fix if it breaks again?
Excelchat Expert 22/08/2018 - 06:51
there are multiple pivots in one sheet and source data was not correct for both of the sheets
Excelchat Expert 22/08/2018 - 06:51
I played around a little bit to understand the issue.
User 22/08/2018 - 06:51
aahhh i see.. ok..
Excelchat Expert 22/08/2018 - 06:52
I created a new pivot similar to yours and it was working fine and hence I realized multiple pivots and data source isnt fine.
User 22/08/2018 - 06:52
so multiple pivots should contain same row/column data
User 22/08/2018 - 06:52
?
Excelchat Expert 22/08/2018 - 06:52
it isnt always like that
Excelchat Expert 22/08/2018 - 06:53
but you have some manual updates as well like column names and all.. so when you are updating all the pivots in one go by clicking on refresh all
Excelchat Expert 22/08/2018 - 06:53
data source should be fine'
User 22/08/2018 - 06:53
ok.. got it
Excelchat Expert 22/08/2018 - 06:53
Did it solve your issue?
User 22/08/2018 - 06:53
thanks for explanation
User 22/08/2018 - 06:53
yes
User 22/08/2018 - 06:53
now i know, and knowing is half the battle :-)
Excelchat Expert 22/08/2018 - 06:53
Thanks for joining. Please provide the highest rating possible.
Excelchat Expert 22/08/2018 - 06:53
:)
Excelchat Expert 22/08/2018 - 06:54
All the best, you will win the battle buddy :)
Excelchat Expert 22/08/2018 - 06:54
you can end the session now. please provide the highest rating, thanks.

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

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

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc