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?
Gord Dibben - 30 Sep 2006 20:15 GMT
How about Copy>Paste Special>Values>OK>Esc before saving to the other folder?
Gord Dibben MS Excel MVP
>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?