Forum Discussion
Solved
Formula not calculating in only one cell
I have one row on one sheet in my workbook not calculating. The formula is correct above and below the row.
I have checked the calculation options and they are set to auto.
Trace precedents and dependents and it shows no differences.
Check carefully that the spelling is exactly the same - perhaps you have "Yellow Corn Raw" on one sheet and "Yellow Corn Raw " (with an extra space) on the other...
6 Replies
- Thank you for your response.
I checked for a circular reference but it was not highlighted as an option to choose so I took that as not present.Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
