View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Relacing all formulas
 
Posts: n/a
Default Replace all formulas in one worksheet to link to different worksh

I want all formulas (in sheet 1 of Workbook 2006) that link to workbook #1 to
now link to same cells in workbook #2. Any suggestions on how to make that
happen without individually changing each cell?