I have manually created a formula in an Excel spreadsheet, and excel thinks that there is an error when in reality there is not. I have told Excel to ignore the error, but when I enter a value in one of the cells with the formula, the formula does not automatically update? How can I fix this?

We have no clue, what you are talking about, cause we can't take a look on your screen. What formular?

Mostly when this happens there is an error in the way the formula was input. Let us know the Excel version you are using and the exact formula that is giving trouble.

Alwayspop back and let us know the outcome - thanks

Ask Your Question

Weekly Poll