Cut-and-paste breaks dependant formulas

[DanielHutchison]

I feel that this is a newbie question- but i've been using excel for 10 years and never personally experienced this.

If I cut and paste a value of formula into a cell, any dependant cell foruma works fine.

However, I want to cut-and-paste formulas into those cells, and all my dependent formulas replace all of those cell references into a #REF error. I assume something about cut-and-pasting throws out the dependent formula pointers to those cells.

How can I cut-and-paste my formulas without breaking the cell references in dependent formulas?

Why copying doesn't break the cell formulas, it updates all my cell references with new row and column addresses. For reasons too lengthy to get into I cannot have these formulas use absolute cell references, so I have to cut not copy.

Thanks in advance for help.
/Dan

[ChemistB]

If it's a single formula or two, you can cut and paste them from the formula box.

If there's more, you can highlight the range and do a search and replace on = changing it to '= then excel sees the formulas as text. Cut and paste them now and then reverse the search and replace.

Does that work?

ChemistB