I have an Excel 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 future growth in the number of records in the database. Have I then, set my ranges up wrong? If so, how should I do it? (A dynamic named range isn't suitable to use for my purposes in Excel because there will be many blanks in some record fields).
Also, why do I keep getting errors on the Excel worksheet if a record is deleted in the access database?
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 future growth in the number of records in the database. Have I then, set my ranges up wrong? If so, how should I do it? (A dynamic named range isn't suitable to use for my purposes in Excel because there will be many blanks in some record fields).
Also, why do I keep getting errors on the Excel worksheet if a record is deleted in the access database?
