My formulas don't refresh automatically

%3CLINGO-SUB%20id%3D%22lingo-sub-2229887%22%20slang%3D%22en-US%22%3EMy%20formulas%20don't%20refresh%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2229887%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20the%20following%20problem%20(I%20tried%20google%20and%20this%20forum%20but%20found%20nothing)%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20an%20external%20software%20writing%20text%20values%20to%20my%20excel%20column%2C%20and%20it's%20working%20fine.%20I%20have%20around%201400%20rows%20filled%20by%20it.%20I%20have%20another%20column%20to%20convert%20each%20of%20these%20values%20to%20General%20(left%20is%20text%2C%20right%20is%20general%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Wojciech_Plonka_0-1616510172288.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F266315i99A678AE25BF8562%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Wojciech_Plonka_0-1616510172288.png%22%20alt%3D%22Wojciech_Plonka_0-1616510172288.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20using%20the%20following%20formula%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Wojciech_Plonka_1-1616510217260.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F266316i4D12386A5CD18C20%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Wojciech_Plonka_1-1616510217260.png%22%20alt%3D%22Wojciech_Plonka_1-1616510217260.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20problem%20is%3A%20in%20the%20past%2C%20everything%20was%20working%20fine%2C%20but%20suddenly%20my%20columns%20can't%20be%20refreshed.%20So%2C%20when%20those%201400%20rows%20are%20filled%20with%20new%20text%20values%2C%20converted%20columns%20remain%20the%20same%2C%20as%20below%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Wojciech_Plonka_2-1616510328697.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F266317i0FC6041859308E6F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Wojciech_Plonka_2-1616510328697.png%22%20alt%3D%22Wojciech_Plonka_2-1616510328697.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20gets%20refreshed%20when%20I%20click%20on%20that%200.264%20value%20twice%20and%20press%20enter%2C%20then%20the%20value%20is%20good%2C%20but%20in%20the%20past%20it%20was%20done%20automatically%20and%20I%20didn't%20have%20to%20press%20enter%201400%20times.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20ideas%20on%20how%20to%20solve%20that%20issue%3F%20I%20have%20automatic%20calculation%20turned%20on%20and%20all%20other%20things%20are%20correct%20as%20well.%3CBR%20%2F%3E%3CBR%20%2F%3EThank%20you%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2229887%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2229990%22%20slang%3D%22de-DE%22%3ESubject%3A%20My%20formulas%20don't%20automatically%20refresh%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2229990%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F878588%22%20target%3D%22_blank%22%3E%40Wojciech_Plonka%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3ESolution%3A%20The%20method%20used%20by%20Excel%20to%20calculate%20formulas%20depends%20on%20the%20settings%20you%20have%20made%20under%20%22Tools%2C%20Options%22%20on%20the%20%22Calculation%22%20tab.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIf%20the%20%22Automatic%22%20option%20is%20activated%20there%2C%20Excel%20automatically%20recalculates%20all%20formulas%20in%20the%20entire%20workbook%20each%20time%20a%20cell%20is%20entered.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EAttention%3A%20By%20pressing%20the%20F9%20key%20you%20activate%20the%20manual%20calculation%20option.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20any%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2229994%22%20slang%3D%22en-US%22%3EBetreff%3A%20My%20formulas%20don't%20refresh%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2229994%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F722750%22%20target%3D%22_blank%22%3E%40Nikolino%3C%2FA%3E%26nbsp%3BI%20tried%20all%20google-proposed%20solutions%2C%20including%20that%20one%2C%20and%20nothing%20helps%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Wojciech_Plonka_0-1616512210492.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F266328i1309E4B209EC5DEA%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Wojciech_Plonka_0-1616512210492.png%22%20alt%3D%22Wojciech_Plonka_0-1616512210492.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2230010%22%20slang%3D%22en-US%22%3ERe%3A%20My%20formulas%20don't%20refresh%20automatically%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2230010%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F878588%22%20target%3D%22_blank%22%3E%40Wojciech_Plonka%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EIt%20seems%20as%20you%20don't%20need%20any%20formula%20to%20convert%20the%20Textual%20Values%20into%20Real%20Values.%3CBR%20%2F%3E%3CSTRONG%3E%3CBR%20%2F%3ESELECT%20ALL%201%2C400%20cells%3C%2FSTRONG%3E%20%26gt%3B%20in%20the%20user%20interface%20click%26nbsp%3B%3CSTRONG%3EDATA%3C%2FSTRONG%3E%20%26gt%3B%20%3CSTRONG%3ETEXT%20TO%20COLUMNS%3C%2FSTRONG%3E%20%26gt%3B%20%3CSTRONG%3EFINISH%3C%2FSTRONG%3E.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3E--------------------------------------------%26nbsp%3B%3C%2FSTRONG%3E%3CBR%20%2F%3EMichael%20(Micky)%20Avidan%3CBR%20%2F%3E%3CSTRONG%3E%3CEM%3E%E2%80%9CMicrosoft%C2%AE%E2%80%9D%26nbsp%3BMVP%20%E2%80%93%20Excel%26nbsp%3B%3C%2FEM%3E%3C%2FSTRONG%3E%3CSTRONG%3E(2009-2022)%3C%2FSTRONG%3E%3CSTRONG%3E%3CBR%20%2F%3E%3C%2FSTRONG%3EISRAEL%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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 rows filled by it. I have another column to convert each of these values to General (left is text, right is general:

Wojciech_Plonka_0-1616510172288.png

I am using the following formula:

 

Wojciech_Plonka_1-1616510217260.png

 

The problem is: in the past, everything was working fine, but suddenly my columns can't be refreshed. So, when those 1400 rows are filled with new text values, converted columns remain the same, as below:

 

Wojciech_Plonka_2-1616510328697.png

 

It gets refreshed when I click on that 0.264 value twice and press enter, then the value is good, but in the past it was done automatically and I didn't have to press enter 1400 times.

Any ideas on how to solve that issue? I have automatic calculation turned on and all other things are correct as well.

Thank you,

 

8 Replies

@Wojciech_Plonka 

Solution: The method used by Excel to calculate formulas depends on the settings you have made under "Tools, Options" on the "Calculation" tab.

If the "Automatic" option is activated there, Excel automatically recalculates all formulas in the entire workbook each time a cell is entered.

 

Attention: By pressing the F9 key you activate the manual calculation option.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote any reply if it helps please, as it will be beneficial to more Community members reading here.

 

 

@Nikolino I tried all google-proposed solutions, including that one, and nothing helps:

Wojciech_Plonka_0-1616512210492.png

 

@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
Numbers formatted as text
Solve, in that case you just have to mark all affected cells with the mouse.
Then you click with the right mouse button on the marker.
Select Format cells from the context menu.
In the following window choose from the formats standard or number.
Confirm with OK and Excel should do the math again.
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?
doesn't work
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