I had both these problems. I am using Office Insider – Fast track for Office Pro Plus. I tried all kinds of things but nothing worked. Full repair, complete uninstall and reinstall, reapply Windows patches, reinstalled .net framework, escalated to MS. No use.
The solution was very simple. I went to Excel – Customize Quick Access Toolbar. At the bottom right corner I chose – Reset – Reset All Customizations. That’s it. Both problems solved.
I myself do not know why it worked. But it did. If you have the same issues, try this one.
