Forum Discussion
Wojciech_Plonka
Mar 23, 2021Copper Contributor
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...
Wojciech_Plonka
Mar 23, 2021Copper Contributor
Thank you for the response.
It is useful in general, but in this case it doesn't help: I need that particular fields to be working fine because they are affecting other fields, and other fields are not refreshing fine as well
It is useful in general, but in this case it doesn't help: I need that particular fields to be working fine because they are affecting other fields, and other fields are not refreshing fine as well
JMB17
Mar 23, 2021Bronze Contributor
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?
- prudyunathMay 11, 2023Copper Contributor
Yes, it's working, Thanks for the solution
- EthanJoJun 13, 2022Copper ContributorThanks 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.
- chamseddine_hamdeniDec 08, 2021Copper Contributorit works for me. I had the same problem. Thanks
- Wojciech_PlonkaMar 24, 2021Copper Contributorit is the only thing that works so far, thank you! But if anyone knows a way for this to be done automatically please let me know