Stack Overflow
Stack Overflow

Questions tagged [excel-2016]

The Excel-2016 tag is used for referencing the spreadsheet component of the Microsoft Office 2016 suite released 22 Sep 2015. The version independent Tag is "excel". If it is about VBA code or an Excel formula or worksheet function, then tag it vba & excel or excel-formula or worksheet-function respectively.

Excel 2016 is the spreadsheet component of the Office 2016 suite released on 22 Sep 2015. It incorporates what was previously the Power Query add-in, additional charting options and Power BI Desktop. details here

From Wikipedia Included in the Microsoft Office 2016 package, along with a lot of new tools included in this release:

  • Power Query integration
  • Read-only mode for Excel
  • Keyboard access for Pivot Tables and Slicers in Excel
  • New Chart Types (Sunburst, Waterfall, Pareto Charts, 3D Data Map etc.)
  • Quick data linking in Visio
  • Excel forecasting functions
  • Support for multi-selection of Slicer items using touch
  • Time grouping and Pivot Chart Drill Down
  • Excel data cards
  • The 'Tell Me' box to search inbuilt functions and operations

For Apple Macintosh Excel 15.0 forms part of the "Office 2016" suite.

Office 2016 for Mac brings the Mac version much closer to parity with its Windows cousin, harmonising many of the reporting and high-level developer functions, while bringing the ribbon and styling into line with its PC counterpart.

For a poignant article on this see Walt Mossberg's article Office for Mac Is Finally a 'First-Class Citizen'.

Links:

1344 questions
24
votes
2 answers

PowerQuery: How can I concatenate grouped values?

If I have the following table (shown in the image below), how can I write a grouped query that would concatenate the grouped results? For this example, I'd want to group by the LetterColumn and concatenate the NumberColumn So the desired results…
Giffyguy
  • 17,946
  • 30
  • 81
  • 147
11
votes
2 answers

Generic Way to Determine the Maximum Allowed Length a of String

Take a look at this property(Given you have a table on the first worksheet): Application.Sheets(1).ListObjects(1).name How many characters can this property contain? Well, after testing out a few strings I've come to the conclusion that its 255,…
David Rogers
  • 2,284
  • 2
  • 30
  • 68
11
votes
2 answers

Upgrading to Office 2016 Reference Error: Microsoft.Office.Interop.Excel

Visual Studio 2015 is giving me an error stating that the "Namespace or type specified in the Imports 'Microsoft.Office.Interop.Excel' doesn't contain any public member or cannot be found." I just started getting this error after upgrading to Office…
Fly Guy
  • 245
  • 1
  • 4
  • 10
10
votes
1 answer

Excel 2016 on Win 10 Tablets

Is there code for capturing screen gestures or screen swipes in Excel 2016 running on tablets? I'm looking for code that I can control with a screen swipe or screen gestures. For example, screen swipe left select a different tab or run code, etc. ??…
FTSC
  • 190
  • 1
  • 7
9
votes
4 answers

"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 lock some rows and columns by using FreezePanes. worksheet.Activate(); worksheet.Application.ActiveWindow.FreezePanes =…
DeniseMeander
  • 728
  • 1
  • 7
  • 23
9
votes
5 answers

How to make Microsoft Web Browser object work in Excel 2016

When I try to insert it, I constantly get the "Cannot insert object" error. It seems to be a known issue with former Excel versions, but I couldn't find any support for 2016. Has anyone been able to make this work? Here are screenshots:
AlKoral
  • 109
  • 1
  • 1
  • 3
8
votes
3 answers

Tables interfere with VBA range variables depending on scope

An Excel file includes VBA-coded user-defined functions (UDFs) that are deployed in tables (VBA listobjects). Now, for reasons that escape me, if the UDF module contains Range variables that are declared outside the scope of any sub or function, I…
Egalth
  • 812
  • 7
  • 22
8
votes
3 answers

"XML parsing failed at line xxx, column 36: illegal xml character" when importing to Power Pivot from SSRS report

Excel 2016 (16.0.6965.2076) SQL Server 2014 (12.0.4213.0) I have an SSRS report with 10 parameters - two are dates and the other 8 are text dropdowns using a query to populate the options. If I try to fetch this report into a Power Pivot Data Model…
3N1GM4
  • 3,057
  • 2
  • 15
  • 36
7
votes
2 answers

Why is my form still in memory

I have the following code opening a form and then doing some stuff. Sub lag_ny_a3() Dim frm As ufNyA3 Set frm = New ufNyA3 frm.Show If Not frm Is Nothing Then MsgBox("Doing stuff") Unload frm End If End…
eirikdaude
  • 2,956
  • 5
  • 20
  • 45
6
votes
3 answers

"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 read data from various places on the network and stores it in cells in this excel file. That all works perfectly. VBA code then saves the…
Davidfox789
  • 63
  • 1
  • 5
6
votes
2 answers

Wrong Excel Window in Focus after Workbook_Open

My recent upgrade to Office 365 / Excel 2016 has caused some unwanted behavioral changes. Workbook("Portfolio Appreciation") contains a Workbook_open procedure which checks to see if Workbook("Index Returns") is open; if it is not, it will open…
Ron Rosenfeld
  • 40,315
  • 6
  • 22
  • 49
5
votes
2 answers

How to have cells dynamically populate based on start and length

Basically, the problem is summarized by the picture below. https://imgur.com/a/vBU2xMK The "Start" column is when the beginning of "Descriptor" variable starts and it populates the number of rows starting according to the value in the "Length"…
user3788581
  • 97
  • 1
  • 6
5
votes
1 answer

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 has execute permissions on certain stored procedures to provide end users read-only data. User accounts don't have access to the…
gbeaven
  • 886
  • 1
  • 9
  • 25
5
votes
1 answer

Positioning labels within chart

I have a spreadsheet containing two charts, in which I want to add some textboxes next to one of the series' points, based on values in a table. I have created two procedures for this, each with its own pros and cons: Sub add_comments(apply_to As…
eirikdaude
  • 2,956
  • 5
  • 20
  • 45
5
votes
3 answers

VBA macro in Excel 2016 for Mac: SaveAs will not work with a CSV file format

I am running a VBA macro in Excel 2016 for Mac. The macro works on Windows platforms with Excel 2016, and on Mac platforms with earlier than the 2016 version. The issue appears specific to Excel 2016 for Mac when trying to export a CSV. The code is…
Kate
  • 163
  • 1
  • 16
1
2 3
…
89 90