View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default how do i maintain same figure with formula link to another file

How about CopyPaste SpecialValuesOKEsc before saving to the other folder?


Gord Dibben MS Excel MVP

On Sat, 30 Sep 2006 10:18:01 -0700, by amp <by
wrote:

if i create a formula linked to another file and i need to save this to
another folder and deleting the original source where i link the file is
there a way that i can maintain the same figure and won't affect it
eventhough the file that link originally was gone?