| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i maintain same figure with formula link to another file
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Q: Can a formula reference a cell to get the file name to link to for data? | Excel Discussion (Misc queries) | |||
| Can I concatenate text in cells to make a working formula? | Excel Discussion (Misc queries) | |||
| Links picking up values from an older version of linked file | Links and Linking in Excel | |||
| Can I embed or link multiple .pdf files into or to an excel file? | Excel Discussion (Misc queries) | |||
| quick way to copy-paste a formula linked to cells in another file | Excel Worksheet Functions | |||
Linear Mode
