Forum Discussion
Formulas Not Calculating in Workbook
Hello, I have a very large workbook with many formulas across different sheets. I currently have this workbook set to manual calculations only. And it is saved in a Sharepoint Directory with autosave...
Just wanted to add a few more possibilities shared in another post, including that the data is stored as Text. (I had to delete a row, set it to "General" or "Number" formatting, then re-try my formulas again to get them to work.)
https://techcommunity.microsoft.com/t5/excel/formulas-displaying-as-text/m-p/3818576/highlight/true#M191220
https://techcommunity.microsoft.com/t5/excel/formulas-displaying-as-text/m-p/3818576/highlight/true#M191220
"I had to delete a row, set it to "General" or "Number" formatting, then re-try my formulas again to get them to work.)" -thanks this worked