Hi.

I'm a heavy Excel user at work. We often create quite large spreadsheet that
use complex worksheet functions provided by 3rd party addins. Typically we
may use functions to draw in data from external sources and then process
those data using a combination of standard Excel worksheet functions and
worksheet functions provided in the 3rd party addins. The spreadsheets
generally take ~10 mins to calculate so we have then on 'manual calculation'.

My question is about how best to arrange and calculate large spreadsheets.

People at work fall into two categories:

1.) Arrange the workbook so that its worksheets have a reasonably clear
dependency order. Then use Shift+F9 to calculate the worksheet one at a time
until you've calculated everything you need.

2.) Use Ctrl+Alt(+Shift)+F9 when you really have to start the whole
calculation from scratch. Otherwise just use F9 to calculate cells who's
dependents have changed. NEVER use Shift+F9. Leave it all to the Excel
dependency tree.

Please can someone suggest some reading material for me related to this.
I've looked in books and on the web but all I've found is answers to very
specific issues. I'm looking for general suggestions for best practice.

Cheers.
--
myNameIsJohn