How to refresh all Cells in an Excel Workbook automatically?

[Guest]

I have an Excel Workbook that is Shared and it uses the Vlookup function to
look up values in another Excel Workbook. Both files are stored in a Network
drive and I use \\server_name\shared_folder\filename.xls format to reference
the file in the first Workbook.

Problem: Upon opening the Shared Workbook, it does not always display the
correct Cells values until I manually press F2 and Enter on each of the
wrong-value Cell.
Is there a way to refresh all the Cells' value without manually pressing F2
and Enter on the affected Cells?

 

[Dave Peterson]

Maybe Edit|Links|Update values

Or even selecting all the cells and
edit|replace
what: =
with: =
replace all

(change all the equal signs to equal signs will force excel to recalc)