Home » Questions » Computers [ Ask a new question ]

Excel 2007 formulas not auto-filling when I drag down?

Excel 2007 formulas not auto-filling when I drag down?

If you write a formula like:

Asked by: Guest | Views: 38
Total answers/comments: 2
Guest [Entry]

"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?"
Guest [Entry]

"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."