How to omit cells from automatic calculation?

[stefanaalten]

I would like to omit some cells (a single column, as it happens) from automatic calculation, but I don't want to switch the entire worksheet/workbook to manual calculation ("F9").

The reason for this is that the column in question contains some fuzzy matching formulas which can take a long time to complete. I'm happy to do this manually at the end of an editing session, whereas the rest of the calculations should update as I edit data.

Is this possible?

Many thanks in advance!

Stefan

---

I wish I could think of a witty clever quote to include in my signature...

 

[Adnym]

I can see why you'd want to do that but I am pretty sure that functionalilty isn't available in Excel. It's either off, or it's on for all cells.

Sorry, I'm sure that's not the answer you wanted!
______________________

Microsoft Office Training