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 ar...
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- Thanks Patrick! I have successfully opened Excel in safe mode using those instructions, I have also successfully opened the name manager upon clicking the button, but it is not showing any specific names. It is blank. I can hit "new", but the "edit" and "delete" buttons are grayed out...sorry to keep hitting you with these issues, they are just frustrating.
- It's possible Excel is not able to render the names in the name manager. It appears something is in there if it won't open unless run in Safe Mode.
What happens if you create a formula and refer to one of those tables?