Access Data Source and Formula References

[Karl Burrows]

Hi!

I have a worksheet that pulls data from an Access database (both version
2000/XP). I then setup formulas to look at the data and return values to
the worksheets. As an example, if the range of the data is from A1:C300
initially, the formula reflects the data range.

My question is, if I then close and reopen the workbook and have since added
another 100 records to the database, will the formulas change to reflect the
new data range or do I need to just amend the formulas to anticipate the
number of records that potentially could be included?

 

[Debra Dalgleish]

You could use a dynamic formula to name the range, and it will adjust as
more data is added. There are instructions here:

http://www.contextures.com/xlNames01.html

 

[Karl Burrows]

Good idea, but if I have 750+ array formulas all running the same range,
won't it take forever to run if it's looking at the entire column or does
the OFFSET stop it at the first blank?