View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vic Vic is offline
external usenet poster
 
Posts: 117
Default VLookups - too long to re-calculate

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?