It should work with 78 too... if you intend to add those columns.

When I opened your workbook and looked at your original named range reference... I saw #REF! errors... so you must have done something wrong when creating the dynamic range formula.

=OFFSET(Data!$A$1,,,COUNTA(Data!$A:$A),78) should work too.
anyways...