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!”
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