Top "Excel-2016" questions

The Excel-2016 tag is used for referencing the spreadsheet component of the Microsoft Office 2016 suite released 22 Sep 2015.

How to call a function on ENTER key in Excel using vba

Google should provide me with ample examples but none of them seem to work What I want: Everytime the user …

excel windows-7-x64 excel-2016 vba
Excel rotate radar chart

I have been trying to create a windrose that displays the occurence of multiple wind speeds and their respective wind …

excel excel-2016 radar-chart
Embed SQL Server Credentials in Excel 2016 (O365) to Refresh Data On-Demand

I am trying to embed credentials into an Excel 2016 workbook for an account on my SQL Server 2008R2 database that …

sql sql-server-2008-r2 excel-2016
Dynamically expand an excel table based on entries in another table

I'm setting up a spreadsheet with the goal of allowing users to enter data by employee and date. I'd like …

excel dynamic excel-formula excel-2016 excel-tables
Is it possible to change the worksheet tab size?

I have lots of sheets in a workbook, all with short names, so is it possible to reduce the default …

excel excel-2016
"Unable to set the FreezePanes property of the Window class" Excel 2016 (office 365)

I've build an excel addin which fills a worksheet with data from a database. I also add some styling and …

c# excel office365 excel-2016
"Application.Quit" leaves Excel running in the background

I have a small excel file that is launched by a scheduling app every 15 minutes. Functions in the excel cells …

vba excel excel-2016
Excel - Freezing Top row shows duplicate top row

This is no programming question, at least I wouldn't put it that way unless I needed VBA for that. The …

excel excel-2016
Excel #NAME? error with IFNA

Strange behavior in Excel 2016 running on Windows 7. Please refer to the screenshots below: In Pic 1, the cell in red box …

excel excel-formula excel-2016