Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2002
    Location
    Anderson, Indiana
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Date of Pivot Table refresh (2003 / 11.5612.5703)

    Is there a way to add a field to a spreadsheet displaying the date (or date and time) of the last pivot table refresh?

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Date of Pivot Table refresh (2003 / 11.5612.5703)

    From Version 2002 onwards, Excel has a worksheet event that can help you.

    The following code will insert the date and time in A1, when PivotTable1 is refreshed.

    Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
    If Target = PivotTables("PivotTable1") Then [A1] = Now
    End Sub

    Right click on the sheet tab of the sheet containting th ePivotTable and place that code in the codepane, changing the Cell to receive teh date as required, and the PivotTable name if necessary.

    Andrew C

  3. #3
    New Lounger
    Join Date
    Mar 2002
    Location
    Anderson, Indiana
    Posts
    23
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Date of Pivot Table refresh (2003 / 11.5612.5703)

    Thanks Andrew. That works great!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •