Get instant live expert help on how to refresh formulas in excel
“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
Hey, I'm working in Excel 2013 and I just created a Pivot table. I would like to have the actual "refresh" button to be present on the worksheet so my colleagues can easily refresh the worksheet whenever they start working in it. Could you help me out how to do this please? Kind regards.
Solved by E. W. in 18 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
how can i add link to excel using a macro that would automatically add them when we refresh
Solved by G. U. in 23 mins