View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Beep Beep Beep Beep is offline
external usenet poster
 
Posts: 101
Default Copying Formula Situation

When one has two versions of the same file open, say €œfrankstaxes.xls€ and
€œfrankstaxes_2.xls€ and one is copying a worksheet from one to the other, how
do you get around Excel renaming all the references so that they include the
local files filename in many of the formulae??