### #REF error

  • Thread starter Thread starter adeel via OfficeKB.com
  • Start date Start date
A

adeel via OfficeKB.com

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
 
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.
 
Or maybe...

edit|Links|Update values

???

adeel via OfficeKB.com said:
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
Click to expand...
 
Back
Top