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...
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
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?- For example, if I type "=sumbeiers", one of the suggested table names, and I hit "enter", I return a "#N/A". I did another one, "=SUBJIS" and that returned "#REF". I did one more (3rd times the charm) "=SUBO" and it returned a value, and then a pop up came up that said "Unable to open https://XXXXX (the name of the link). The Internet site reports that the item you requested could not be found. I previously broke all links and pasted values, so I didnt think that would happen. I also realized I made a tiny mistake, the name manager I opened in the safe mode excel was a blank "Book 1". I opened the specific excel file I am having a hard time with in safe mode, confirming it opened this way, then tried name manager and name manager still wouldnt open.