I have a few files with lots of simple formulas (30,000 +). Lately, I have seen some inaccurate numbers being produced by these files and after troubleshooting it turns out that some of these formulas did not / and will not calculate.
This is not a simple turn on autocalc or press F9 problem. Believe me, I have tried it. The only way I can get the cell that will not calculate to respond is be entering edit mode (F2) and pressing enter.
Has anyone experienced this?
Bookmarks