View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dan
 
Posts: n/a
Default How do I stop VLOOKUP from asking what spreadsheet to look in?

Every time I use VLOOKUP on a certain PC it asks what path to take. The path
is in the VLOOKUP so it shouldn't ask. To select the path in every cell is
cumbersome. My other PC works fine. Is there a setting to make it stop
asking? It is in Excel 2003 on Windows XP for both PC's.