Auto-refresh pivot table without losing undo buffer

Peterson · #1 03-25-2020, 06:56 PM

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

When I modify the data table, the macro dutifully refreshes the pivot table, but the undo buffer is cleared.

Is there a way to auto-refresh the pivot table such that the undo buffer is not deleted?

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