Windows 10: Protect only formulas from delete/backspace allow edit in cells

This seems to be a mystery online how to protect a cell (Calculations only) on a protected sheet with a formula included from being deleted when someone hits Delete or Backspace in the cell without deleting the formula as well. Is there a way to protect only the Formula/Mathematics from being removed when someone does this? I have a Gantt chart that updates an end date from a task duration. The end date cell can also be edited to update the actual complete time cell updating my timeline. Any help please I just don't need my staff erasing my formulas but need the cell editable. Thanks

:)

 

Puts formula in cell instead of result


You have formatted the Cell(s) as text. Delete the contents and change format to General and enter again.

Or change the Cell to general format and re-enter from the formula bar.

 

Simple spreadsheet will not allow editing

Hello TeresaRutledge,



Thanks For the forum entry.



THis information will give you a good understanding what can be done and what cant.

http://www.windowsphone.com/en-US/how-to/wp7/office/office-mobile-faq

there is as well the information that is most likely related to the issue

You might not be able to edit a Microsoft Office document on your phone depending on what's in it or how it was last saved. Here are some of the more common things that make a document read-only on your phone.

The file is:

• Saved as an older type of Microsoft Office document, such as a Microsoft Word 97-2003 document (.doc), Microsoft Excel 97-2003 workbook (.xls), or Microsoft PowerPoint 97-2003 presentation (.ppt).
  
• Digitally signed.
• Marked as final.
• Protected using rights management.
• Protected with a password.
• Protected with restricted editing rights.

Microsoft Word documents are read-only if they have:

• Track changes enabled.
• Frames.
• Custom markup (customxml, sdt tags, or smart tags).
  
• XML where the XML tags have unsupported values.

Microsoft Excel workbooks are read-only if they have:

• Formulas that aren't supported on the phone.
• Scenarios.
• Data validation in one or more cells.
• Array formulas.
• Data tables.
• Slicers.
• Macros enabled.
• Large column or row widths.
• Formulas that contan links or references to other workbooks.
• Formulas with structured references.
• Formulas that contain references, content, or formatting beyond cell IV16384.
  
• Longer formulas, such as a formula that is longer than 512 characters or has more than 30 arguments in it.
  
• Shared workbooks with tracked changes.
• Workbooks with dialog sheets.
• XML markup that isn't formed correctly.
• OLE objects or ActiveX controls.

For Microsoft OneNote notebooks:

• You can’t edit a page from a notebook that was sent as an email attachment.
• A notebook that is shared on SkyDrive or on a Microsoft SharePoint site and marked as read-only.
  
• A page that only contains content that’s not supported in Microsoft OneNote Mobile, such as ink drawings, shapes, or unsupported images.
  
• A notebook that has a corrupted page.

For Microsoft PowerPoint presentations, you can only make certain types of edits on your phone. Some examples include editing text in a text box, changing the order of slides, or hiding slides. For more information about editing a PowerPoint presentation
on your phone, see
Using Microsoft PowerPoint Mobile 2010.



Best Regards

 

Puts formula in cell instead of result


Sometime when a cell does not produce the correct solution with a formula, there may be a hidden entry/format there that would mess with it. Right click the cell and choose "clear contents" then try the formula again. Is this the only cell doing this, or are others showing the same problem??