Forum Discussion
Pivot table in power query
ThisWorkbook.Connections("Combined_Financials_Sector").Refresh
note that Background refresh option should be checked. In the Excel UI, you can access this setting by clicking on "Connections" in the "Data" ribbon, selecting a connection, and clicking on "Properties". The "Enable background refresh" setting is in the dialog box that opens.
you're right, it's a difficult process.
If I import it directly from the power query as a pivot table report, I have a problem.
I am currently renewing with these codes.
Private Sub CommandButton1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
Sheets("Combined_Financials").Range("Combined_Financials_Sector").ListObject.QueryTable.Refresh BackgroundQuery:=True
Sheets("Symbols_Price").Range("Combined_Price_Sector").ListObject.QueryTable.Refresh BackgroundQuery:=True
End SubHow do I refresh the "Combined_Financials_Sector" in the background.
ThisWorkbook.Connections("Combined_Financials_Sector").Refresh
note that Background refresh option should be checked. In the Excel UI, you can access this setting by clicking on "Connections" in the "Data" ribbon, selecting a connection, and clicking on "Properties". The "Enable background refresh" setting is in the dialog box that opens.
I did what you said but I am getting error.
Sorry, this is not English. I can not read it.
rubayatyasmin
"note that Background refresh option should be checked. In the Excel UI, you can access this setting by clicking on "Connections" in the "Data" ribbon, selecting a connection, and clicking on "Properties". The "Enable background refresh" setting is in the dialog box that opens."
I marked the place you mentioned here. but still i am getting error.
Can you paste the error? It would be easy to troubleshoot.
Thanks