how do i maintain same figure with formula link to another file by amp 30.09.2006 17:18:01 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?

Re: how do i maintain same figure with formula link to another file Gord Dibben <gorddibbATshawDOTca> 30.09.2006 19:15:02 How about Copy>Paste Special>Values>OK>Esc before saving to the other folder? Gord Dibben MS Excel MVP On Sat, 30 Sep 2006 10:18:01 -0700, by amp <by amp[ at ]discussions.microsoft.com> wrote: [Quoted Text] >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?