VBA Update different of UpdateAll from Excel

Refresh All is often problematic, especially if you have queries that return their results to tables and then have pivot tables which use those tables. The best way to do this is to use code which does all refreshes in the correct order:

Option Explicit

Sub MyRefreshAll()
    Dim oSh As Worksheet
    Dim oLo As ListObject
    Dim oQt As QueryTable
    Dim oPc As PivotCache
    Dim oPQ As WorkbookQuery
    'First do all querytable son all worksheets
    For Each oSh In Worksheets
        For Each oQt In oSh.QueryTables
            oQt.Refresh False
        Next
        For Each oLo In oSh.ListObjects
            If Not oLo.QueryTable Is Nothing Then
                oLo.QueryTable.Refresh False
            End If
        Next
    Next
    'Then do all PowerQuery queries
    UpdatePowerQueriesOnly
    'finally, update pivots
    For Each oPc In ActiveWorkbook.PivotCaches
        oPc.Refresh
    Next
End Sub

Public Sub UpdatePowerQueriesOnly()
    Dim lTest As Long, cn As WorkbookConnection
    On Error Resume Next
    For Each cn In ThisWorkbook.Connections
        lTest = InStr(1, cn.OLEDBConnection.Connection, "Provider=Microsoft.Mashup.OleDb.1")
        If Err.Number <> 0 Then
            Err.Clear
            Exit For
        End If
        If lTest > 0 Then cn.Refresh
    Next cn
End Sub

The code in UpdatePowerQueriesOnly courtesy:

https://www.excelguru.ca/blog/2015/08/19/update-refresh-power-queries-with-vba/