Worksheet protection in Excel is not a security feature. On the Data tab, in the Queries & Connections group, click Edit Links.What you need to know about Excel worksheet protection You can also investigate which links are in the workbook. If you accidentally replace a formula with a value and you want to restore the formula, click Undo immediately after you enter or paste the value.Ĭlick Don’t Update, and contact workbook's owner. When you replace a formula with its value, Excel permanently removes the formula. How do I prompt in the same way for every user of this workbook? If this check box is cleared, the links are automatically updated, and no alert is displayed. Under General, clear the Ask to update automatic links check box. Users who open the workbook on another computer are not affected. This option affects every workbook opened on the computer. How do I not prompt for all workbooks I open, and update the links automatically? You can answer the startup prompt in a consistent way, and avoid seeing the startup prompt for this workbook. How can I not see the prompt again if I prompt the same way every time? On the Data tab, in the Queries & Connections group, select Edit Links. Select Don’t Update, and contact workbook's owner. How can I not see this prompt after someone else created the workbook? After opening the workbook, on the Data tab, in the Connections group, click Edit Links, and then update the links only from the sources that you need.

If the data does not need to be the most current, you can save time by not updating all of the links. How can I update without it taking so long? What if I don't want my current data replaced with new data? 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. 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?

Open office spreadsheet