You can copy the values returned by the VLOOKUP and paste them over the
formulas.

How many VLOOKUPs are you running? Off how large a table array? With how
much RAM on your computer? The answer to all of these questions would
determine whether there is a way to speed up your calculations.
--
Brevity is the soul of wit.


"Vic" wrote:

Is there a way to modify a file so that the vlookup formula is replaced by a
direct cell link for which it is looking up?

Or how can I help my file to calculate and save more quickly if I keep the
vlookups in the workbook?