Get instant live expert help on I need help with automatically refresh pivot tables

“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 there, When I click on Pivot Table>Analyse> Refresh All in the "Results"sheet of the workbook, I need to click on the Refresh All button several times for all the pivot tables to be updated within the workbook. Can you please show me a way that only one click is needed to refresh all pivot tables?
Solved by V. B. in 26 mins
I have a workbook with pivot tables which are tied to a powerquery. The pivot tables are refreshing fine, however, the powerquery does not refresh.
Solved by Z. S. in 30 mins
The pivot table on Tables tab will not refresh with the entire spread sheet data on 2nd tab.
Solved by S. F. in 13 mins
I have the error "Cannot download the information you requested" when I click "Refresh All". I have used the "Find" function to no avail. I have looked at "named ranges", "tables" and "Pivot Tables" too. I'm stuck.
Solved by C. J. in 30 mins
query auto-refresh isnt working but the pivot table auto refresh is working!
Solved by V. J. in 15 mins