I found some example on how to name a range to get a Dynamic Data Source for my Pivot Tables. However he said that on trying to run this formula in Insert > Name > Define is not ok. I copied the exact formula. What is wrong with my syntax ?

= OFFSET(Data!$A$1,0,0,Count A(Data!$A:$A),7)