How can I get Data Analysis & Solver to stay in my Data tab?

%3CLINGO-SUB%20id%3D%22lingo-sub-2763784%22%20slang%3D%22en-US%22%3EHow%20can%20I%20get%20Data%20Analysis%20%26amp%3B%20Solver%20to%20stay%20in%20my%20Data%20tab%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2763784%22%20slang%3D%22en-US%22%3E%3CP%3EWhenever%20I%20exit%20Excel%2C%20I%20have%20to%20manually%20re-enter%20the%20location%20for%20Add-ins%20like%20Data%20Analysis%20and%20Solver.%20It%20will%20appear%20in%20the%20ribbon%20until%20I%20close%20the%20Excel%20sheet.%20When%20I%20open%20Excel%20again%2C%20my%20add-ins%20do%20not%20appear%2C%20even%20though%20they%20are%20checked%20under%20%22manage%20Excel%20Add-ins.%22%20In%20Ribbon%20Customization%2C%20I%20also%20notice%20that%20there%20is%20no%20%22Analyze%22%20group%20under%20the%20Data%20Tab%2C%20which%20is%20where%20Solver%20and%20Data%20Analysis%20appear%20after%20manually%20locating%20them%20with%20the%20Browser.%20How%20can%20I%20get%20these%20to%20stay%20on%20my%20ribbon%3F%20I%20have%20even%20uninstalled%20and%20reinstalled%20Microsoft%20Office.....%20I've%20spent%20two%20days%20with%20Microsoft%20Support%20and%20so%20far%20nothing%20has%20worked.%20Thanks%20for%20the%20help!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2763784%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Whenever I exit Excel, I have to manually re-enter the location for Add-ins like Data Analysis and Solver. It will appear in the ribbon until I close the Excel sheet. When I open Excel again, my add-ins do not appear, even though they are checked under "manage Excel Add-ins." In Ribbon Customization, I also notice that there is no "Analyze" group under the Data Tab, which is where Solver and Data Analysis appear after manually locating them with the Browser. How can I get these to stay on my ribbon? I have even uninstalled and reinstalled Microsoft Office..... I've spent two days with Microsoft Support and so far nothing has worked. Thanks for the help!

0 Replies