#REF! F2 Enter

[LEWI_74]

Hi,

I have received a model back from a colleague and the majority of cells are now the #REF! message.

I sent it absolutely fine.

When I press F2 then Enter, the cell returns back to the correct value.

Can someone please tell me why Excel does this AND also whether there is a quicker way to get all the #REF! cells to values without having to individually click into each cell.

Thanks

 

[GlennUK]

Show some sample formulas.

 

[LEWI_74]

=IF(L$2='Input workings'!$A$61,0,IF(L$2='Input workings'!$A$63,INDEX(('Helston inputs'!$K7:$V7)*'Input workings'!L$102^(L$5-'Input workings'!$J$8)*'Input workings'!L$109*'Input workings'!L$110*'Input workings'!L$111*'Input workings'!L$112*'Input workings'!L$113*'Input workings'!L$114*'Input workings'!L$115,MATCH(L$1,'Helston inputs'!$K$2:$V$2,0)),IF(L$2='Input workings'!$A$62,INDEX(('Helston inputs'!$K7:$V7)*'Input workings'!L$109*'Input workings'!L$110*'Input workings'!L$111*'Input workings'!L$112*'Input workings'!L$113*'Input workings'!L$114*'Input workings'!L$115,MATCH(L$1,'Helston inputs'!$K$2:$V$2,0)))))

 

[GlennUK]

I don't know what would cause it, but you could do Edit/Replace = with = Replace All to refresh all formulas.

 

[LEWI_74]

Thank you, all sorted with the suggestion you made.