For example, the source may be on a network, and you may not be connected to that network. Excel cannot update from a source that is not connected. Press Alt+E+S+V to paste the formula as its value, or select Home > Clipboard > Paste > Paste Values.
If you accidentally replace a formula with a value and you want to restore the formula, select Undo immediately after you enter or paste the value. When you replace a formula with its value, Excel permanently removes the formula.
Previous versions of Excel hide the links in names that are not currently in use in the workbook. The links have always existed and are no longer hidden. To remove the link, select Break Link.Ĭan I replace a single formula with its calculated value?
0 kommentar(er)
