Description:
When i open my spreadsheet, the formulas are removed and replaced with “VALUE!”. Once i click into the cell and press “ENTER”, the “VALUE” disappears and the calculation works.
It seems to happen with not every file but occasionally.
I attached screenshots of my spreadsheet with my Posting. I could also provide the Spreadsheet itself but as a new user i have not the permission.
We have registered a bug for this particular file and the issue with values upon opening for further investigation.
As of now I recommend setting up array of cells with dates to the Date format and then recalculating all formulas in the workbook to display other values.
I believe it comes from the regional settings. Which ones are set up in your file? You can find them in File tab > Advanced Settings > Regional settings - please share a screenshot.