Formulas to remain constant

[backyardfun]

I have a row of cells that are all formulas that contain other cells for data. When the data cells are cut and pasted into another cell, the formulas are automatically updated with the new cell address. I do not want this to happen. How can the cell addresses in the formula remain constant even when these data cells are moved? Thanks!

[AlKey]

In Excel 2010 go to FIle, Options, Formulas, in Workbook Calculations select Manual and check Enable iterative Calculation.

[Ron Coderre]

Without more details, I think this approach may work for you...
Use the INDEX function to reference the cell you want to always point to.
Example:
This formula will always reference cell I3...even if you cut it and paste it elsewhere.
=INDEX(I:I,3)

Caveat: If you insert/delete columns or move Col_I that reference will move.
To prevent that scenario, too...try this formula:
=INDEX(1:1048576,3,9)

Does that give you something to work with?

[backyardfun]

yes. thank you very much!

[backyardfun]

I was using if/then so the cell would show blank instead of a 0 if there was no data in source cell. Is there a way to do that with index?

[janerko]

You can use in your formulas INDIRECT function, for example:
Suppose you have in cell A10 formula =INDIRECT("A1") then you can move cell A1 anywheres the formula in cell A10 will reffering always to cell A1.