Sounds like you may have calculation set to manual. Try
Tools/Options/Calculation & check Automatic.
Bob Umlas
Excel MVP

"Chi" wrote in message
...
I created a drop down list using Data Validation (cell C6) from data that I
linked from another workbook onto this worksheet in this workbook. I
created
a VLookUp that looks up the value from C6 to return a value in B8:
=VLOOKUP($C6,'By Case'!$A$2:$E$200,2). The formulas work fine, but the
values do not automatically show unless I double click into cell B8 and
press
enter. I've tried updating the link, but that didn't do it. Please
advise!
Thanks!