Performance

[plake]

I'm going to increase the number of markets I monitor - one market a worksheet with quite a few excel calculations.

Any suggestions re performance on the following - remember it is one market per worksheet

Put multiple markets in a worksheet

All worksheets in one copy of excel
Multiple copies of excel with small number of sheets in each
Multiple computers

Use VBA code instead of excel worksheets

More memory
Dual/quad-core processor
Multiple computers

[Ian]

I think BA can only "see" one instance of Excel.

I've monitored up to about 24 different markets into one worksheet, but I seem to remember thet there is a upper limit.