excel function list autocomplete window is not working

%3CLINGO-SUB%20id%3D%22lingo-sub-2416555%22%20slang%3D%22en-US%22%3Eexcel%20function%20list%20autocomplete%20window%20is%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2416555%22%20slang%3D%22en-US%22%3E%3CP%3EFor%20everyone%20else%2C%20when%20you%20type%20in%20a%20cell%20%22%3Ds%22%20an%20autocomplete%20window%20of%20excel%20function%20list%20pops%20up.%20I%20have%20tried%20checking%20formula%20autocomplete%20as%20described%20here%20with%20no%20success%3A%26nbsp%3B%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-formula-autocomplete-6d13daa5-e003-4431-abab-9edef51fae6b%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Fuse-formula-autocomplete-6d13daa5-e003-4431-abab-9edef51fae6b%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20have%20also%20tried%20uninstalling%20and%20reinstalling%20office%3CBR%20%2F%3EI%20have%20also%20checked%20all%20options%20and%20verified%20that%20anything%20related%20is%20checked%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22tpitera80_0-1622818430314.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F286293i46EDBFCECC767BA0%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22tpitera80_0-1622818430314.png%22%20alt%3D%22tpitera80_0-1622818430314.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22tpitera80_1-1622818456179.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F286294i049910F484338661%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22tpitera80_1-1622818456179.png%22%20alt%3D%22tpitera80_1-1622818456179.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2416555%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-2977583%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20function%20list%20autocomplete%20window%20is%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2977583%22%20slang%3D%22en-US%22%3E%3CP%3EUp.%20I%20am%20also%20experiencing%20the%20same.%20Does%20anyone%20know%20how%20to%20resolve%20this%3F%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2977782%22%20slang%3D%22en-US%22%3ERe%3A%20excel%20function%20list%20autocomplete%20window%20is%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2977782%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1221948%22%20target%3D%22_blank%22%3E%40errol1214%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20formula%20auto-complete%20this%20setting%20is%20responsible%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20382px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F327769i765287FCD6D3F3F8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPlease%20check.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

For everyone else, when you type in a cell "=s" an autocomplete window of excel function list pops up. I have tried checking formula autocomplete as described here with no success:  https://support.microsoft.com/en-us/office/use-formula-autocomplete-6d13daa5-e003-4431-abab-9edef51f...

I have also tried uninstalling and reinstalling office
I have also checked all options and verified that anything related is checked

tpitera80_0-1622818430314.png

tpitera80_1-1622818456179.png

 

 

5 Replies

Up. I am also experiencing the same. Does anyone know how to resolve this? Thanks!

@errol1214 

For formula auto-complete this setting is responsible

image.png

Please check.

@Sergei BaklanThanks, Sergei! But that is also my current setting.

 

errol1214_0-1637184134761.png

 

@errol1214 

When I have no idea, sorry.

 

You may try in safe mode (Win+R -> excel /safe) to check if any add-in drops that functionality.

 

Just in case, simple repair / reinstall not always works, to be sure you need to uninstall with fix as here

image.png

Uninstall Office from a PC (microsoft.com), but you lost all your settings.

No worries, sir! I will try your suggestion and let you know. Just want to add, I also noticed that when this happened, I also can't drag any open tabs on Google Chrome. Not sure if it is connected though. Appreciate your inputs, sir!