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...
Wojciech_Plonka
It seems as you don't need any formula to convert the Textual Values into Real Values.
SELECT ALL 1,400 cells > in the user interface click DATA > TEXT TO COLUMNS > FINISH.
--------------------------------------------
Michael (Micky) Avidan
“Microsoft®” MVP – Excel (2009-2022)
ISRAEL
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
- 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?
- it 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
- it works for me. I had the same problem. Thanks
- 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.
