Forum Discussion
autocomplete stopped working after update
Office 365 just updated. Now, autocomplete only works for some columns. So if I'm in column A, and typing the exact same text from the cell directly above, the text will suggest autocomplete and I ca...
Late to the party, but same issue in an O365 shared spreadsheet with customized views that used to have working auto-complete, it seemed to randomly stop working.
Tried clearing caches, different browsers, duplicating sheets, inserting rows, removing capitalizations from headers, etc.
Apparently the "randomly" was me enabling freeze panes.
Solution for me was disabling Freeze Panes (View > Freeze Panes > . Removed Freeze Panes and auto-complete started recognizing non-header cells again.
Tried reenabling Freeze Panes via both Freeze Top Row and Freeze Panes and the functionality broke again both times.
Hope this helps someone.
Dan_L2265 I am using excel in Teams and this also worked for me. Autocomplete will not work if I freeze panes.