Get instant live expert help on I need help with refresh excel formulas

“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

I need help creating a macro in excel to refresh a data connection, drag down cartain formulas and then copy / paste special / values so the formula is only left in the last row of data
Solved by S. F. in 12 mins
I need to refresh my excel sheet from a data base that keeps changing, however I lose old data every time I refresh. How can I refresh without losing previous information?
Solved by K. C. in 19 mins
is there a way that I can auto fill formulas in columns that are adjacent to a query based table? for instance, in the sample attached the query will return data in columns A-F, but the number of rows can vary at each refresh. Is there a way to have the formulas in columns H and I automatically populate to the new rows that appear at refresh?
Solved by O. F. in 26 mins
query auto-refresh isnt working but the pivot table auto refresh is working!
Solved by V. J. in 15 mins
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