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:

1509 questions
33
votes
3 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
  • 20,378
  • 34
  • 97
  • 168
11
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
  • 806
  • 2
  • 9
  • 28
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,601
  • 4
  • 39
  • 84
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
  • 255
  • 1
  • 4
  • 12
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
  • 200
  • 2
  • 8
10
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
  • 119
  • 1
  • 1
  • 4
8
votes
6 answers

ISBLANK returns False for empty cells having Formulas

In Excel 2016, a cell with formula which is not yet calculated appears blank. But still ISBLANK returns False. I am trying to find a way to return True for the cell having formula which is not yet calculated and is actually Blank. Can someone help…
Maltesh
  • 383
  • 2
  • 6
  • 14
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
  • 962
  • 9
  • 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,372
  • 3
  • 19
  • 40
7
votes
1 answer

GetObject("winmgmts:... crashes Excel 2016 with no Errors

I am debugging some VBA code I've written in Excel 2016, and this sub is crashing Excel 2016 on windows Server with no errors. It is crashing on the Set RegObj = GetObject... Sub TestPrinter() On Error GoTo e Dim RegObj As Object 'This…
Joe Bauer
  • 572
  • 1
  • 9
  • 22
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
  • 3,106
  • 6
  • 25
  • 50
7
votes
2 answers

How to programatically add a hyperlink to a cell in a worksheet using office-js?

I'm working on an Excel add-in using the JavaScript APIs to build add-ins in Excel 2016. The problem I have is not to place the url/link in the cell - I rather want to make this url clickable (as you may know it from entering a url into a cell and…
Eric Haas
  • 121
  • 1
  • 7
6
votes
1 answer

Visual Studio Tools For Office (Excel 2016 Workbook) Designer Showing Blue Screen

So I'm trying to start a VSTO Excel Workbook project and cannot seem to get the designer to actually open the spreadsheet I've seeded the project with. The designer just shows a blue screen and doesn't let me actually edit the spreadsheet. This also…
6
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
  • 1,522
  • 2
  • 20
  • 40
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
  • 1
  • 5
1
2 3
99 100