why doesnt my quick analysis button show up in excel

If you use Excel 2013, you have Quick Analysis – a powerful feature that allows you to quickly analyze data.īelow is an overview of the Quick Analysis tool in Microsoft Excel 2013. One of Excel’s most useful functions is the ability to develop graphs and charts from information which can then be easily analyzed. This dynamic tool can be employed in a multitude of ways, from tracking time, to finances and even sales. Override quick analysis Refresh Button functionality (afaiu this is impossible.Microsoft’s spreadsheet program, Excel, is one of the most useful tools that any manager’s disposal. RefreshMenuItem.Click += RefreshMenuItemClick Īnd don't forget to subscribe the event when the add-in is started: Application.SheetBeforeRightClick += Application_SheetBeforeRightClick ĭisplay my custom menu despite Quick Analysis kicking in. RefreshMenuItem.Click -= RefreshMenuItemClick RefreshMenuItem.Caption = 'Refresh My Data' Var refreshMenuItem = (OfficeCore.CommandBarButton)GetCellContextMenu().Controls.Add(menuItem, missing, missing, 1, true) // where missing = global:: If (true) //range.IntersectsWithAnyExcelTable()) <- this code works fine but I commented it out for the purpose of showing the problem (in this case the custom popup meny should appear ALWAYS):Ĭonst OfficeCore.MsoControlType menuItem = If the selected range belongs within a named excel table we display the refresh menu item at the right click context menu. GetCellContextMenu().Reset() // reset the cell context menu back to the default Here is the code I'm using inside ThisAddin.cs: void Application_SheetBeforeRightClick(object worksheet, Excel.Range range, ref bool cancel) I suppose it has something to do with the Quick Analysis functionality interfering with my custom context menu overrides. My modified version of the code from the example works like a charm when I right click outside a named table range:īut it doesn't get displayed when you right click inside a named table range:

I'm following this example to create a custom rightclick custom menu for an excel add-in with VSTO and display it under certain conditions (rightclick inside a range of an Excel named table).

Why doesnt my quick analysis button show up in excel