#1
|
|||
|
|||
Auto-refresh pivot table without losing undo buffer
I'm trying to auto-refresh a pivot table, with the following code:
Code:
Private Sub Worksheet_Activate() Worksheets("Daily Totals Pivot Table").PivotTables("PivotTable4").PivotCache.Refresh End Sub Is there a way to auto-refresh the pivot table such that the undo buffer is not deleted? |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Undo auto indent | Karen J. | Word | 3 | 02-07-2018 03:24 PM |
How do I undo auto striking when I type? | emeraldfalls | Word | 6 | 05-02-2014 01:15 AM |
Pivot table auto print. For multiple values. | Nicholaspoe | Excel | 0 | 10-08-2013 09:08 PM |
Auto Refresh Pivot Table on Timer | bremen22 | Excel | 2 | 10-01-2013 01:00 AM |
Pivot Table Refresh | tpcervelo | Excel | 0 | 09-14-2010 06:54 AM |