hi Vic,

there are several suggestions for sppeding up VLOOKUPs here
http://www.decisionmodels.com/optspeede.htm

regards
Charles Williams
Decision Models

"Vic" wrote in message
...
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?