title: How to NOT refresh backgroundQuery vba
body: <p>Does anyone know how to stop the refresh query table to constantly refreshing and only refresh itself once. he constant refresh, is making my excel spreadsheet run slow.</p>
  
  <pre><code>With ActiveSheet.QueryTables.Add(Connection:= _
          "URL;" &amp; FilePath, _
         Destination:=temp.Range("A1"))
     .Name = "Deloitte_2013_08"
      '    .CommandType = 0
         .FieldNames = True
         .RowNumbers = False
        .FillAdjacentFormulas = False
       .PreserveFormatting = True
      .RefreshOnFileOpen = False
     .BackgroundQuery = True
    .RefreshStyle = xlInsertDeleteCells
   .SavePassword = False
  .SaveData = True
          .AdjustColumnWidth = True
    .RefreshPeriod = 0
        .WebSelectionType = xlEntirePage
       .WebFormatting = xlWebFormattingNone
      .WebPreFormattedTextToColumns = True
     .WebConsecutiveDelimitersAsOne = True
    .WebSingleBlockTextImport = False
   .WebDisableDateRecognition = False
  .WebDisableRedirections = False
  
         .Refresh BackgroundQuery:=False
  
  End With
  </code></pre>