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:

1509 questions
4
votes
2 answers

Passing multiple ranges as AGGREGATE's array parameter

I would be grateful if anyone knows whether the following issue is documented and/or what the underlying reasons are. Assuming we have, for example, the numbers from 1 to 10 in A1:A10, the following…
XOR LX
  • 7,632
  • 1
  • 16
  • 15
4
votes
2 answers

Office-js Excel: Get filename of newly saved file

How can I get filename of newly saved file? Normally, I can get the filename using: Office.context.document.url However, when the user opens a new workbook, it doesn't really have a filename, and oddly enough this line of code doesn't work even…
cs_pupil
  • 2,782
  • 27
  • 39
4
votes
1 answer

Why does my function assume a missing argument is there?

I have a function which updates a form, "LoadingInterface". The function looks like this: Private Sub updateLoadingBar(Optional tekst As String, Optional barOnePerc As Long, Optional barTwoPerc As Long) If Not IsMissing(tekst) Then …
eirikdaude
  • 3,106
  • 6
  • 25
  • 50
4
votes
1 answer

Maintaining a dynamic named range in a chart when copying a worksheet

I am trying to automate charts for a spreadsheet with a lot of worksheets. I'm building all the charts/graphs I need on a template worksheet and making them dynamic using named ranges (OFFSET + COUNT). Once I have this template completed I would…
Peter
  • 103
  • 9
4
votes
1 answer

Connecting to Oracle Database through Excel

I'm trying to connect to an Oracle Database on our server from an Excel sheet, but am having trouble understanding why. I currently have both 32-bit and 64-bit Oracle 12c installed in different ORACLE_HOMEs and have a 32-bit installation of Excel…
Jimenemex
  • 3,104
  • 3
  • 24
  • 56
4
votes
1 answer

VBA Excel: how to get row and column number of named range?

I have the following problem and it's driving me NUTS! I work on a large database program in Excel, and I'm trying to retrieve the row and column numbers of specific named ranges. The following code used to work (temp_entryvalue is the name of the…
The Brainlet Exterminator
  • 143
  • 1
  • 1
  • 4
4
votes
1 answer

how to read the amount of used or free memory in Excel 2016 VBA

I can't seem to find a VBA command that returns the memory in use or the memory available. In Excel 2013 there was Application.MemoryUsed but when I try that in Excel 2016 I get "Type mismatch", regardless if I use dim myVar as variant …
Joe Phi
  • 340
  • 1
  • 4
  • 14
4
votes
1 answer

Maximum number of conditional formatting rules in Excel 2016?

Inspired by this question, I went down a rabbit hole trying to discover the maximum allowable number of conditional formatting rules that can be applied to a cell. I have never heard of such a limit. In my research I did find references to Excel…
E. Merckx
  • 427
  • 3
  • 12
4
votes
1 answer

EPPlus Add Worksheet with Latest Version of Office Losses All Macros

When you run the following code on a file that has any VBA macro's whatsoever: using (ExcelPackage xlPackage = new ExcelPackage(new FileInfo("Test.xlsm"))) { xlPackage.Workbook.Worksheets.Add("TestTab"); xlPackage.Save(); } You get the…
David Rogers
  • 2,601
  • 4
  • 39
  • 84
4
votes
4 answers

Is there an equivalent of Python's pass statement in VBA?

I would like to know if there is an equivalent of Python's pass statement in VBA. I am using Excel 2016.
user3848207
  • 3,737
  • 17
  • 59
  • 104
4
votes
6 answers

Remove AM/PM from "time" cell

I am calculating all the hours/minutes/seconds of all calls made on our PABX system. The cell has to be "time" format to display correctly. BUT, this adds an AM/PM at the end of the result as if it was the time. Whereas I just want it to display as…
user7500527
4
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
  • 133
  • 2
  • 17
4
votes
0 answers

Get a "Invalid procedure call or argument (Error 5)" in Excel 2016 but not in Excel 2011

Here's the relevant code in the BurnUpApplication Module: For Each slice In slices graph.drawSlice slice Next Which calls the following code in a CBurnUp class: Public Sub drawSlice(slice As CSlice) With…
K -
  • 209
  • 2
  • 9
4
votes
1 answer

Excel 2016 Workbook.BeforeClose event firing every other time bug

8/25/16 Update: I updated Office 2016 (now on v 16.0.7167.2040) and it seems to have been fixed. I didn't change any add-ins or anything. Maybe Microsoft does look at these issues! Hopefully, anyone else with this issue can update their version and…
michaelf
  • 469
  • 6
  • 20
3
votes
0 answers

Worksheet Id changes after reopening excel sheet in Office 2016 version

I have created an excel add-in using Office JS API and I am storing my worksheet's metadata with the worksheet id. When I save my worksheet at that time my worksheet id is "{4BBBF664-CB10-44A3-9B15-B13CBACC4D9A}". But when I reopen the Excel sheet…
Poojan3037
  • 310
  • 1
  • 9
1 2
3
…
99 100