Selective calculation

[PH NEWS]

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

 

[Niek Otten]

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

| 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
|
|

 

[PH NEWS]

Thanks. But the preceding cells will have changed, therefore a calculation
will take place. I can't take the info to another sheet as it has to be on
view in that one and manual calculation is no good, as my conditional
formats have to appear instantly to stop the person inputting from making
mistakes. I really need to be able to keep all the info on one sheet and use
auto calc but be able to exclude certain columns.
----- Original Message -----

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