Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table update automatically?
i have created pivot table i have problem when ever i enter data "Data Sheet"
then after i have to always manually update Pivot report sheet. Is there any way i can automatically update Pivot report sheet when ever i entry data in "data sheet" ****al shah |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table update automatically?
You could use an event procedure to refresh the pivot table when its
sheet is activated. For example: Private Sub Worksheet_Activate() ActiveSheet.PivotTables(1).PivotCache.Refresh End Sub To use this code, right-click on the sheet tab, and choose View Code. Copy and paste the code onto the sheet's module, where the cursor is blinking. ****al shah wrote: i have created pivot table i have problem when ever i enter data "Data Sheet" then after i have to always manually update Pivot report sheet. Is there any way i can automatically update Pivot report sheet when ever i entry data in "data sheet" ****al shah -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatically update the pivot table | Excel Discussion (Misc queries) | |||
Pivot table does not automatically update when underlying data cha | New Users to Excel | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
automatically update pivot tables when dynamic named range is expa | Excel Discussion (Misc queries) |