|
|
#2
01-30-2015, 01:26 AM
|
||||
|
||||
You can add a little macro like this via the Worksheet_activate event
Code:
Sub PivotMacro()
Dim pt As PivotTable
Set pt = ActiveSheet.PivotTables("MyPivot")
pt.RefreshTable
End Sub
Also see that your data source is dynamic ( like a table)
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Countif with filter | epnhakon | Excel | 3 | 08-29-2014 09:46 AM |
 COUNTIF Formula
|
teza2k06 | Excel | 3 | 02-13-2014 12:37 PM |
| Countif | hockeytown | Excel | 3 | 01-05-2013 08:06 AM |
|
Countif issue
|
Katy I | Excel | 2 | 07-11-2012 06:30 AM |
|
Countif with 2 criteria
|
ibrahimaa | Excel | 3 | 05-23-2011 11:23 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode