Top "Excel-2010" questions

The Excel-2010 tag is used for referencing the Excel Version 2010 spreadsheet application from Microsoft.

Why does ActiveSheet.FilterMode returns False when sheet has filter?

I'm using the following code in an attempt to detect a filter applied to a column in a table and …

vba excel excel-2010 listobject
Add tooltip to Excel Add-in Custom Ribbon UI XML

I am creating an Excel Add-In that has a custom Ribbon UI. I would like to add a tooltip for …

excel-2010 add-in ribbonx
Error: "The query returned more data than will fit on a worksheet"

When I refresh my workbook, the following message pop-ups : "The query returned more data than will fit on a worksheet"? …

error-handling popup excel-2010 excel-external-data
MsgBox focus in Excel

I am calculating a lot of data with VBA in Excel and want to show a MsgBox when it's done. …

vba excel excel-2010 msgbox
Excel VBA changing my formulas in a table?

Has anyone come across a situation where Excel seems to manipulate your formulas. I have a sheet where I have …

excel vba excel-2010 listobject
How can I avoid Excel show Save dialog when automation app exits

I have a excel automation application written in Delphi, that accesses a given excel workbook and extracts applying some internal …

excel delphi excel-2010 office-automation
AVERAGEIFS does not work, but AVERAGE(IF( does

We have a large spreadsheet that we use to calculate performance for race car drivers. It has been stable for …

excel excel-2010 average named-ranges
Macro button under customized ribbon tab tries to open old Excel file

I created a custom ribbon tab on my Excel like Excel_app_v1.xlsm, and a button under this ribbon …

excel excel-2010 ribbon ribbon-control vba
Creating Excel Macro for Exporting XML to a certain folder

I need to create a macro (which I have never done before) and if you guys can guide me to …

excel excel-2010 export-to-xml vba
conditional formatting entire row if cell contains text

I have an excel sheet where I'm trying to use conditional formatting but it doesn't seem to work as I …

excel excel-2010 row conditional-formatting