Excel vba refresh wait

by

I was working with a PowerPivot model, and I wanted to Refresh the data before I saved and closed the Model. However, excel just closed the model before the refresh was complete, and the model resumed refreshing on opening.

Adding the following line right after the RefreshAll method, did the trick:

ThisWorkbook.RefreshAll
Application.CalculateUntilAsyncQueriesDone

I hope it works for you too.

Make sure that you Disable Events to speed things up.

Note that I am using Excel 2010, I am not sure if this method is available in older versions.

More Related Contents:

  1. Refreshing all the pivot tables in my excel workbook with a macro
  2. Excel VBA – How to add dynamic array formula
  3. Check if the file exists using VBA
  4. Compare double in VBA precision problem
  5. Row count on the Filtered data
  6. Excel VBA Macro: User Defined Type Not Defined
  7. Automate IE via Excel to fill in a dropdown and continue
  8. Run-Time error 1004 Excel 2013
  9. VBA – Write all possible combinations of 4 columns of data [duplicate]
  10. Excel VBA to Export Selected Sheets to PDF
  11. Remove duplicates from array using VBA
  12. Controlling Internet Explorer local intranet using Excel VBA
  13. Return RGB values from Range.Interior.Color (or any other Color Property)
  14. excel VBA run macro automatically whenever a cell is changed
  15. Translate text using vba
  16. “Can’t find Project or Library” for standard VBA functions
  17. How do I issue an HTTP GET from Excel VBA for Mac
  18. Copy sheet and get resulting sheet object?
  19. Sending mail using Outlook where the Send method fails
  20. How do I apply a SumIf Formula in a VBA Sub? Getting Error 1004
  21. Using a variable for row in (row,column) for a range in VBA
  22. Unicode string literals in VBA
  23. How to get the path of current worksheet in VBA?
  24. Excel VBA to match and line up rows
  25. Change font color for a part of text in cell
  26. Create a new object using the text name of the class
  27. How to open a workbook specifying its path
  28. GET pictures from a url and then rename the picture
  29. How to highlight selected text within excel
  30. How to fix a VBA “type mismatch” error after switching to 64-bit Excel

Leave a Comment