Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
refresh option of pivot table not working
What am I doing incorrectly that is making it so that I do not even have the
"refresh data" option available to me in my pivot table? I want to modify the spreadsheet so that my pivot table and graph automatically update if I change information in the mother formula worksheet. Thank you for your help. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
refresh option of pivot table not working
The 'Refresh every x minutes' option will be available if the pivot
table is based on an external data source. You could use programming to update the pivot table if the worksheet is activated. For example, right-click on the pivot table worksheet's sheet tab, choose View Code, and paste the following code: Private Sub Worksheet_Activate() Dim pt As PivotTable For Each pt In ActiveSheet.PivotTables pt.PivotCache.Refresh Next pt End Sub ceejgrl wrote: What am I doing incorrectly that is making it so that I do not even have the "refresh data" option available to me in my pivot table? I want to modify the spreadsheet so that my pivot table and graph automatically update if I change information in the mother formula worksheet. Thank you for your help. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2k Pivot Table refresh scenario | Excel Discussion (Misc queries) | |||
Pivot Table Refresh Problem | Excel Worksheet Functions | |||
Refresh scenario information in a pivot table | Excel Discussion (Misc queries) | |||
Pivot table Data refresh | Excel Worksheet Functions | |||
Pivot Table Refresh Options | Excel Discussion (Misc queries) |