Forum Discussion
My formulas don't refresh automatically
Hi, I have the following problem (I tried google and this forum but found nothing): I have an external software writing text values to my excel column, and it's working fine. I have around 1400 r...
I'm not sure why your formulas are not re-calculating, but can you force excel to recalculate the workbook using Ctrl+Alt+Shift+F9?
Thanks JMB17. This worked for me. I've been searching on and off for a solution for a few weeks now, for the same situation: formulas not refreshing automatically. In my case it only seems to affect formulas that reference text in cells on other sheets, and only in one workbook. The Excel settings are correct (Automatic calculation), and I even tried "F9" and "Shift+F9" with no success. Until now I've had to F2 each cell and hit Enter. Using "Ctrl+Alt+Shift+F9" is a good work around, but I would REALLY like to know how to fix the problem.