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- 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?
Yes, it's working, Thanks for the solution
