Sheets ActiveWorkbook. FormatConditions i. Yes No. Skip to content.
Sometimes that's a helpful feature, but in this case it makes it hard to go back and edit the cell. Crna Gora - Srpski.
Schweiz - Deutsch. Forgot your username? You may want to check for and remove any of these type of links.
India - English. When you break a link to a source, all formulas that use the source are converted to their current value. For those on Macs I'm on Excel v15.
It is possible to accidentally create a link by moving or copying a range, worksheet, or chart between workbooks. Because this action cannot be undone, you may want to save a version of the file. Canada - English. Indonesia Bahasa - Bahasa.
For example, the source may be on a network, and you may not be connected to that network. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site the association bonus does not count. Only i amended to find ". This will select the cells that have Data Validation applied. For references in Cells: