Hi Rob,

Try doing a search and replace = sign with the = sign, then recalc.

Let me know how that worked.

Thanks,
Peggy

"Rob" wrote:

this is my formula
='H:\EXCELDAT\MATRIX\CM2006\[DKBSD06.XLS]FLAT BSD #2 PT'!$D$288
i need to change CM2006 to COST MATRIX 2006 in a column containing 3,500
cells.

when selecting a 3,500 cell column to replace items in the formula, i am
allowed to replace one by one, but when select replace all, excel returns $0
and then locks up.

help?