Quiz

  1. 1
    Advanced

    When inspecting a workbook, you locate the following VBA code in the Sheet4 code module. What will this code do? Private Sub Worksheet_Activate() ActiveSheet.PivotTables("pvtSales").PivotCache.Refresh End Sub

  2. 2
    Advanced

    When inspecting a workbook, you locate the following VBA code in the ThisWorkbook code module. What will this code do? Private Sub Workbook_SheetActivate(ByVal Sh As Object) ActiveWorkbook.RefreshAll End Sub

  3. 3
    Advanced

    What is the easiest way to ensure that the Sales PivotTable is refreshed every time you open the file?