Dynamic Pivot Table/Macro Question

[Musician78]

Hi,

I have created a macro for a table I made. Macro works fine, except when I refresh my dataafter running the macro, my data file changes from:
=OFFSET(DATA!$A$1,0,0,COUNTA(DATA!$A:$A),COUNTA(DATA!$1:$1)) to:
=OFFSET(DATA!#REF!,0,0,COUNTA(DATA!#REF!),COUNTA(DATA!$1:$1))

I do not know what might be causing this.

If you have a fix, please let me know. Thanks.

 

[Musician78]

Bueller? Bueller? Bueller?