I have a very complex workbook that won't automatically update formula
results which contain the vlookup function to another worksheet. "F9" doesn't
update the formulas but clicking in the formula (making it active) does.
There are thousands of these formulas which need to be updated and I can't
determine the automatic method.

This seems to be a problem occasionally when I have the very large and
complex workbooks.

Example formula:

=VLOOKUP($C47,'Merch Spd'!$A$17:$AN$74,35,FALSE)*1000
--
Matt