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.

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

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

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

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