Forum Discussion
Power Query NOT Refreshing on Refresh All VBA
I have built a large report using purely Excel with Power Query. A lot of steps are involved in PQ and later loaded in Excel sheet the final report. I tried to automate it but Refreshing is not worki...
//You've got to give the workbook time to refresh. I always add an
Application.OnTime(NOW + "00:05:00", ThisWorkBook.NameOfCloseModule)
//and then make a separate module (NameOfCloseModule) that you can //put your ThisWorkbookSave and ActiveWorkbook.Close procedures.
Now it won't try to save then close for 5 minutes, or however long you want.
--Nate