Forum Discussion
terryli246
May 18, 2024Copper Contributor
Formula delay
Whenever I inputted a formula in a cell, the formula showed up with some delay. However, when I inputted number into the cell, it showed up with no delay. May I know how to fix it?
SergeiBaklan
May 18, 2024MVP
Do you mean you see result of formula calculation with some delay, or you see formula itself instead of the result?
terryli246
May 19, 2024Copper Contributor
SergeiBaklan It is the formula itself.
E.g. when I input "=sum", the text and formula suggestion show up with some delay. However, when I input "sum" without the equal sign, the text can show up with no delay.
- SergeiBaklanMay 19, 2024MVP
If to enter formula by default formula autocomplete starts working suggesting you existing functions and names. You may try to disable it
and check if there is the difference in behaviour or not. Usually it shall be now significant difference, but all depends on your configuration.
- terryli246May 19, 2024Copper Contributor
SergeiBaklan your suggestion works well, thank you for your help.
- SergeiBaklanMay 19, 2024MVP
terryli246 , you're welcome