1.) The author is referring to efficient spreadsheet design as you surmised.

2.) Don't know what "read off" means in this context.

3.) The concern is...
Just be aware that if your code bugs out, and you have no error trap, the Workbook will be left in manual calculation and NO properly designed spreadsheet should ever be used with calculation in manual.
Your code doesn't appear to have an error trap.