Pivot Table Data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a data table in a sheet that I keep adding to. a pivot table was
created from this data. how can i have new data added to the data table show
up in the pivot table when i refresh.
 
I don't think you can do this without a User Defined Function such as ...

'/========================================/
Function IsHidden(rng As Range) As Boolean
Application.Volatile
On Error Resume Next
IsHidden = False
If rng.EntireColumn.Hidden = True Or _
rng.EntireRow.Hidden = True Then
IsHidden = True
End If
End Function
'/========================================/

Hope this helps,
Gary Brown
 
Back
Top