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.