**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.*