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.

Hi Spencer

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

for details

Cheers
JulieD

"Spencer Hutton" wrote in message
...
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


"JulieD" wrote:

Hi Spencer

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

for details

Cheers
JulieD

"Spencer Hutton" wrote in message
...
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.