Forum Discussion
Excel formula not evaluating
I am facing a rather quirky issue with some of the excel formulae. In a few cells, the formula is not getting evaluated. It is showing the formula text instead. The formula evaluation tool shows "the...
Without a file (without sensitive data) one can only guess.
My assumption is that there is an inaccessible link to another sheet in the conditional formatting.
Anyway, here is a small solution, without guarantee.
Go to Home -> Conditional Formatting -> Delete Rules -> Delete Rules in Entire Sheet.
So the message should go away.
I would be happy to know if I could help.
My assumption is that there is an inaccessible link to another sheet in the conditional formatting.
Anyway, here is a small solution, without guarantee.
Go to Home -> Conditional Formatting -> Delete Rules -> Delete Rules in Entire Sheet.
So the message should go away.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
