Forum Discussion
When typing =, suggestions in addition to regular formula's/functions are popping up
I am using Microsoft Excel 365 Version 2210 (up-to-date) and when I am in a cell and type "=" I am used to formulas/functions being suggested such as =SUM, =SUBTOTAL, and etc....now however, there are more items popping up than I am used to and it is really frustrating and preventing me from getting to what I am used to working towards. For example when I start typing "=S" in a cell, a bunch of suggestions for what appear to be tables (evidenced by a blue table logo instead of the "fx" logo show up like =SUBA, =SUBC, =SUBN, and these are clearly not formulas. I want to turn off excel suggesting the blue table. I checked my settings, I have "use table names in formulas" unchecked in my excel and this issue is still happening. I also do not have any active tables in my workbook. Please see attached picture for reference. Please advise, thank you!!
8 Replies
- The setting you mentioned turns off structured references but does not affect the autocomplete you're seeing. It may be worth checking out the name manager for those items that appear to be tables.
- Thanks Patrick! Unfortunately upon clicking the "name manager" button multiple times nothing happens....I restarted excel and everything, no pop-ups or actions.
- It sounds like there may be an exorbitant amount of named items in the name manager. I've encountered this a few times. I'd start by opening Excel in safe mode and then try the name manager again.
https://support.microsoft.com/en-us/office/open-office-apps-in-safe-mode-on-a-windows-pc-dedf944a-5f4b-4afb-a453-528af4f7ac72
