Thread: copying formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
derksj derksj is offline
external usenet poster
 
Posts: 2
Default copying formula

When i copy a formula from old.xls to new.xls
then it shows the old values

=((('[Old.xls]Eng-clusters'!$N$13+'[Oud.xls]Eng-clusters'!$N$53)/4)+('[Old.xls]Eng-clusters'!$N$40+'[Old.xls]Eng-clusters'!$N$101))*[Old.xls]Algemeen!$E$55

How can i change this that the new file name is used