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?
Barrfly
Have you set the cells to General?
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
just saw this calc problem again. setting to general did not help. I did do a find "=" and replace with "=" and it seems to reset the formula.
Hi barrfly,
Very intriguing, can't say I've heard of that one before, but thanks for the "fix"
This just happened to me. It is extremly wierd and scary as one trusts that with F9 all cells are recalculated.
Barryfly, thans for posting the fix.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks