I have a spreadsheet linked to an access database. On one worksheet I have some formulas that include ranges to calculate some of the data from the import.

However, each time I refresh the data, the upper cell named in the range within the formula has increased. E.g. $A$2:$A$10000 could read $A$2:$A$10020 at next refresh.

Is this typical of a link to access? I set all ranges from 2:10000 to take into account growth in the number of records in the database. Have I then, set my ranges up wrong? If so, how should I do it?

Also, why do I keep getting errors if a record is deleted in the access database?