|
» Automatically Refreshing a PivotTable Report
CATEGORY: Excel Pivot Tables |
VERSIONS: All Microsoft Excel Versions |
|
To automatically refresh the data in a PivotTable Report: • Step 1: Automatically update the source data range Name • Step 2: Add a VBA Event to automatically refresh the PivotTable report 1. Press Alt+F11, and then double-click the sheet name in the VBAProject pane. 2. From the left dropdown list above the Module sheet, select Worksheet, and from the right dropdown list, select Activate. 3. Copy the code from the Macro Event Activate in the screenshot. 4. Press Ctrl+S to save the workbook, and then press Alt+F4 to close the VBE. The PivotTable report is refreshed automatically upon selecting the sheet that contains it. Note: To find the PivotTable report name (in this example, PivotTable1), select a cell in the PivotTable report, right click, and then select Table Options from the shortcut menu. |
| Screenshot // Automatically Refreshing a PivotTable Report |
  |
|
RATING:
3.11
VIEWS: 28025 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- Microsoft Access Version 2002 Step by Step
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- Positioning: The Battle for Your Mind
- Personal Finance for Dummies
- MP Managerial Accounting w/ Topic Tackler, Net Tutor, & PowerWeb
Related MS EXCEL TIPS:
Terms
and Conditions of use
The applications/code on this site are distributed as is and without warranties
or liability. In no event shall the owner of the copyrights, or the authors
of the applications/code be liable for any loss of profit, any problems
or any damage resulting from the use or evaluation of the applications/code.
