I am here this year to say thank you as this has just helped me.
@MPeixe1107
4 жыл бұрын
OMG! I'm form Brazil and I had this exactly problem, I have done a dashboard with slicers and after rename the file, I could not refresh the pivot tables anymore. I have watched so many youtube videos for 3 days hunting for a solution and this one was the only one that explained about the problem. Thank you so much!!!
@mininair1025
Ай бұрын
Thank u it worked...!! Feels good when we can fix our issues❤
@yunusakgul6309
3 жыл бұрын
great solution thanks. I have searched about this problem 1 hour an finally find this video great thanks
@ViniciusOliveira-od7sn
Жыл бұрын
Awesome! Saved me hours of work. Thanks
@johnhartley2438
4 жыл бұрын
Gr8 I was looking all over for this fix. Big TY
@manoharm1125
7 жыл бұрын
my source file for pivot table is in another workbook and I am getting the same error... cannot open the source file... please help to resolve this problem
@gordbz1
2 жыл бұрын
Great solution ...thanks for the information
@dubbedabomassaod9571
20 күн бұрын
شكرا جزيلا لك ❤
@AbdiOsman-cp8zz
Жыл бұрын
I try to change source data however says reference isn't valid can you please help
@ahmedabuouf6020
2 жыл бұрын
Thanks for your videos
@krishj8011
4 жыл бұрын
thanks... very useful... awesome....
@SonHoang-dt1dz
Жыл бұрын
Thank for sharing, i fixed it❤❤
@ditship
5 жыл бұрын
Thanks Sir!
@rizkyramdhany4549
5 жыл бұрын
I had similar case, i try your method too but it still doesnt work. a few minute later i found it actually because i use "refresh all" when i have pivot that database didnt exist because i've already delete it. (I have 2 Pivot sheet 1 connected with new database and 1 Pivot connected with old database that i've been deleted and im using hide sheet). just FYI for someone who have similar case. Anyway thanks for the problem solution :)
@katesukhanova5530
Жыл бұрын
I keep having a slightly different problem when refreshing data - the error says “command requires at least two rows of source data..." I go to change data and my selected range is still there and it’s 200 rows, so I’m puzzled what to do :(
Пікірлер: 21