Hello,

I was wondering why certain lookups that I am performing won't function properly. I have say workbook1 and I want to do a lookup in workbook2 but when I click on workbook2 the lookup won't work ie I get the message "update values" for workbook.
It was working before but just doesn't work now, anyone have any ideas?
So I have something like
=VLOOKUP(A2,'[workbook2.xls]sheet1'!B:B,1,false)

Many thanks