Forum Discussion
Errors in spreadsheet
My dates are 5 numbers and cannot change them. My dollar amounts will not add. The sum formula does nothing. How can you tell if a spreadsheet is locked?? It almost acts like it is .. I have sw...
Hi Bill,
If you haven't sorted this yet try this,
First under Excel Preferences check what Calculation options are set, see screenshot. Secondly on the review Tab there should be "Protect Sheet" and "Protect Workbook" options, if they are entitled Protect then the sheet is unprotected and Unprotect means its protected.
For your dates check that the cell isn't formatted as text.
Hope this helps,
Rich
