This made one of the worst days at the office even bad, please help!
I couldn't work out why my cells are not recalcualting.
I checked Tools > Options - Calculations and this is set to automatic.
However if I click into a cell or press F2 and then Enter this seems the only way the cell will update.
A typical formula which won't update:
=IF(ISERROR(VLOOKUP($D68,'08 Feb'!$G$2:$H$200,2, FALSE)),0,VLOOKUP($D68,'08 Feb'!$G$2:$H$200,2, FALSE))
Thanks in advance for any insight.
I couldn't work out why my cells are not recalcualting.
I checked Tools > Options - Calculations and this is set to automatic.
However if I click into a cell or press F2 and then Enter this seems the only way the cell will update.
A typical formula which won't update:
=IF(ISERROR(VLOOKUP($D68,'08 Feb'!$G$2:$H$200,2, FALSE)),0,VLOOKUP($D68,'08 Feb'!$G$2:$H$200,2, FALSE))
Thanks in advance for any insight.