Locked but editable cells?

[bittsen]

I have a sheet I'm trying to make that will draw data from a table. I have that part but sometimes I need to edit one of the cells that are pulled from the data.
For instance, if the table cell is empty, but on the output I need a value, I would enter it manually.

This is easy if I don't have locked cells but if the sheet is saved then I lose the formula.

Is it possible to have a cell that has a locked formula that can be overridden, but the override won't save?

[6StringJazzer]

When you type a value into a cell containing a formula, that formula is gone forever. There is nothing built in to Excel that can restore the formula after this happens (except "undo"). It would be possible but a bit complicated develop a custom solution, and would require VBA.

Using VBA, you could have a "shadow" version of this sheet that is a copy of the sheet, and upon saving, VBA could use the shadow sheet to restore any formulas that were overwritten by values. This would be very specific to your file and difficult to program without having your file. The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.