Auto-refresh pivot table without losing undo buffer

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Auto-refresh pivot table without losing undo buffer

FAQ

Mark Forums Read

Thread Tools

Display Modes

03-25-2020, 06:56 PM

Peterson

Windows 10 Auto-refresh pivot table without losing undo buffer

Office 2016

Competent Performer

Join Date: Jan 2017

Posts: 143

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

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?

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:16 PM.