Pivot Table Data

[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.

 

[JulieD]

Hi Spencer

base the pivot table on a dynamic range ... check out
http://www.contextures.com/xlPivot01.html

for details

Cheers
JulieD

 

[Guest]

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