I have a workbook with two sheets, has data that refreshes from a DB and the other is the finished report with all the formulas.

The problems is when I "refresh data" and something new is added the formulas change. This morning 77 records where added and a$2:a$25000 changed to a$2:25077. Any ideas?