| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Refresh Pivot Table from other worksheet cell entry
Hello
I am needing to write a code so that if I was to enter a value into a particular column (say A:A) on one worksheet (named Sheet1), the PivotTable1 on another worksheet (named Sheet2) will refresh. I'm sure this will be easy for someone out there! Thanks in advance! Shane. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Refresh Pivot Table from other worksheet cell entry
You could refresh the pivot table when Sheet2 is activated.
Right-click on the Sheet2 tab, choose View Code, and paste the following code where the cursor is flashing: Private Sub Worksheet_Activate() PivotTables(1).PivotCache.Refresh End Sub ShaneS wrote: Hello I am needing to write a code so that if I was to enter a value into a particular column (say A:A) on one worksheet (named Sheet1), the PivotTable1 on another worksheet (named Sheet2) will refresh. I'm sure this will be easy for someone out there! Thanks in advance! Shane. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Refresh Pivot Table from other worksheet cell entry
Thanks Debra.
I have this code on sheet2 already and it is very useful. But I still need to be able to refresh when entering text into a column from another worksheet, as this sheet shows a reference from the pivot table. As it is, I need to refresh sheet2, and then go back to sheet1. Is it possible to refresh from a particular column entry in sheet1? Thanks. Shane. "Debra Dalgleish" wrote: You could refresh the pivot table when Sheet2 is activated. Right-click on the Sheet2 tab, choose View Code, and paste the following code where the cursor is flashing: Private Sub Worksheet_Activate() PivotTables(1).PivotCache.Refresh End Sub ShaneS wrote: Hello I am needing to write a code so that if I was to enter a value into a particular column (say A:A) on one worksheet (named Sheet1), the PivotTable1 on another worksheet (named Sheet2) will refresh. I'm sure this will be easy for someone out there! Thanks in advance! Shane. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Refresh Pivot Table from other worksheet cell entry
You can use the Worksheet_Change event on Sheet1, e.g.:
Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 5 Then Sheets("Sheet2").PivotTables(1).PivotCache.Refresh End If End Sub ShaneS wrote: Thanks Debra. I have this code on sheet2 already and it is very useful. But I still need to be able to refresh when entering text into a column from another worksheet, as this sheet shows a reference from the pivot table. As it is, I need to refresh sheet2, and then go back to sheet1. Is it possible to refresh from a particular column entry in sheet1? Thanks. Shane. "Debra Dalgleish" wrote: You could refresh the pivot table when Sheet2 is activated. Right-click on the Sheet2 tab, choose View Code, and paste the following code where the cursor is flashing: Private Sub Worksheet_Activate() PivotTables(1).PivotCache.Refresh End Sub ShaneS wrote: Hello I am needing to write a code so that if I was to enter a value into a particular column (say A:A) on one worksheet (named Sheet1), the PivotTable1 on another worksheet (named Sheet2) will refresh. I'm sure this will be easy for someone out there! Thanks in advance! Shane. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Refresh Pivot Table from other worksheet cell entry
Great!
Works a treat. Thanks Debra. "Debra Dalgleish" wrote: You can use the Worksheet_Change event on Sheet1, e.g.: Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 5 Then Sheets("Sheet2").PivotTables(1).PivotCache.Refresh End If End Sub ShaneS wrote: Thanks Debra. I have this code on sheet2 already and it is very useful. But I still need to be able to refresh when entering text into a column from another worksheet, as this sheet shows a reference from the pivot table. As it is, I need to refresh sheet2, and then go back to sheet1. Is it possible to refresh from a particular column entry in sheet1? Thanks. Shane. "Debra Dalgleish" wrote: You could refresh the pivot table when Sheet2 is activated. Right-click on the Sheet2 tab, choose View Code, and paste the following code where the cursor is flashing: Private Sub Worksheet_Activate() PivotTables(1).PivotCache.Refresh End Sub ShaneS wrote: Hello I am needing to write a code so that if I was to enter a value into a particular column (say A:A) on one worksheet (named Sheet1), the PivotTable1 on another worksheet (named Sheet2) will refresh. I'm sure this will be easy for someone out there! Thanks in advance! Shane. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- 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 | |||
| Create refresh button in worksheet to refresh Pivot Table Data | Excel Worksheet Functions | |||
| Adding button to worksheet to refresh pivot table data | Excel Worksheet Functions | |||
| refresh a new worsheet on pivot table refresh | Excel Worksheet Functions | |||
| Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
| Pivot Table REFRESH Flaw -- Saves Old Data in Selection Area AFTER REFRESH | Excel Programming | |||
Hybrid Mode
