Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-25-2020, 06:56 PM
Peterson Peterson is offline Auto-refresh pivot table without losing undo buffer Windows 10 Auto-refresh pivot table without losing undo buffer Office 2016
Advanced Beginner
Auto-refresh pivot table without losing undo buffer
 
Join Date: Jan 2017
Posts: 41
Peterson is on a distinguished road
Default 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?
Reply With Quote
Reply

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
Auto-refresh pivot table without losing undo buffer 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 without losing undo buffer 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


All times are GMT -7. The time now is 10:27 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft