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...
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.
