Select the range with the problem formulas (or all the cells)

Edit|Replace
what: = (equal sign)
with: =
replace all

Excel should see that mass change just like you hit F2|enter on each cell.

"adeel via OfficeKB.com" wrote:

I have a Master Workbook that have linkes to various workbooks. Some time
when I update any of workbook it displayed #REF error in my Master Workbook.
I have to double click on every cell which then shows actual value. please
help me on this error. and tell me some short way to rectify this. thanks

--
Message posted via http://www.officekb.com

--

Dave Peterson