The arrays will only be recalculated if the preceding cells have changed.
If you still want to exclude them, move them to another sheet, set calculation to manual and use SHIFT+F9 (Calculate Sheet) to
calc the Active Sheet

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"PH NEWS" wrote in message ...
| Hi all,
|
| I have a spreadsheet with about 20 columns of data, 3 of which are
| long-winded array formulas. I have some conditional formats and simple IF
| functions in the other 17 columns. I would like to keep the sheet calc to
| auto, but this makes entry slow because of the 3 columns of arrays. Is there
| a way to exclude the array columns so I can keep the auto calc?
|
| Thanks in advance,
|
| SPL
|
|