If you write a formula like:
=sumproduct((something=$A1)*(something=$B1)) Giving a result of 8. Usually the references and results change as you drag it down into other cells. Well,the references do, but the result doesn't!?
It used to work, but just stopped doing it a few minutes ago (after it crashed actually).
I know it will be something silly, but what just happened? How do I make it work as it should. What am I doing wrong?
43 Answers
It seems your formulas are not automatically updating. Pressing F9 will force a manual recalculation and should recalculate.
To fix it, click the big Ribbon Button, go in Excel Options. Choose the Formulas panel, and choose Automatic Workbook Calculations.
Now the question is: was something else broken too?
2Go to Options >> Advanced and select the Enable fill handle and cell drag-and-drop check box. This should fix this issue.
Whenever something stops working after a crash, there is the possibility that something got corrupted. I would start with repairing your office installation. That should replace all of your Office related program files while leaving your settings and data untouched. If it's still busted, then you should try a re-install.
Sadly, that solves more Microsoft problems then you would expect.
