Dynamic Named Ranges Where Data Is Manually Added And Deleted

A lot of the Workbooks that I design for use by myself and colleagues require data to be copied in from external data sources. To avoid named ranges from failing, I always use the following method:

Calculate the length of the data set:

Code:
=COUNTA(INDIRECT("'Data Sheet'!"&"$A:$A"))

(There will be no gaps in the data, hence a count is fine.) This named range is called DSROWCOUNT.

Example named range for the data in column A:

Code:
=OFFSET(INDIRECT("'Data Sheet'!"&"$A$1"),1,0,DSROWCOUNT-1,1)

I use INDIRECT to ensure my named ranges do not fail if the data is deleted (accidentally or intentionally), as #REF! errors will occur.

The problem with this method is that it automatically makes the Workbooks volatile because of the use of OFFSET and INDIRECT, hence the Workbooks always needs to be in manual calculation mode to be usable.