I have to double click on every cell
which then shows actual value.

Maybe check that calc mode is set to auto?
(via Tools Options Calculation tab)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"adeel via OfficeKB.com" <u32736@uwe wrote in message
news:7855bdea8bf76@uwe...
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