Pivot table- range dynamic - offset - do not refresh correct

[bojzon]

I have pivot table (left upper corner - J1) on sheet with data (A150000). Number of rows changes a lot, and I always DELETE PREVIOUS PIVOT TABLE AND NAME!!, and create new new pivot table from the beginning (Data are named "RangeDynamic" and "=OFFSET(" & ShtName & "!R1C1,0,0,COUNTA(" & ShtName & "!C1),COUNTA(" & ShtName & "!R1))". When I try to refresh pivot table, offset reference is with 1 or 2 additional columns than current region is, so refresh fail (columns with empty header). The same effect is if I delete all empty columns, refresh last cell, save,..But I have no problems if destination for pivot table is new sheet ?
Any suggestions?

 

[SkipVought]

Hi,

Seem that you have your PT on the same sheet as your source data along with a DYNAMIC NAMED RANGE for your source data.
That's ok IF....

1) your source data is ISOLATED from your PT (empty column between)

2) you have NOTHING ELSE in ROW1. You have your PT in J1. Move your PT to J2.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[bojzon]

You are master!
Thanks
Bojzon