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
6
votes
2 answers

How to reference and refresh a QueryTable in Excel 2016 in VBA

I'm trying to refresh a query on a cell change, however I can't figure out how to reference the query. My code: Sheets("Roster Query").QueryTables(0).Refresh Just errors out with: Run-time error '1004': Application-defined or object-defined…
Douglas Gaskell
  • 9,017
  • 9
  • 71
  • 128
6
votes
1 answer

Error "Select method of Range class failed" when selecting range in VB.Net Excel workbook

(First time poster, so please let me know if I did anything wrong with the question formatting/placement/content. Thanks) Brief intro: I'm working on an Excel workbook that was developed by someone else at my company in Visual Studio 2010 for Excel…
rsmith
  • 63
  • 1
  • 3
6
votes
5 answers

How do I break on errors?

I have a Function that has some bug in it somewhere causing it to return #VALUE when I try to execute it in excel. I have no idea where the error is, and stepping through the code is just tedious. So I'd like the debugger to break as soon as an…
quant
  • 21,507
  • 32
  • 115
  • 211
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
  • 53,870
  • 7
  • 28
  • 60
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://i.stack.imgur.com/H8YzR.jpg 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…
user3788581
  • 97
  • 1
  • 6
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
  • 3,106
  • 6
  • 25
  • 50
5
votes
5 answers

How do I keep Cell Referencing in Excel if I replace sheet?

I have a sheet with a bunch of data. I then have a different sheet that references multiple cells in that first sheet. If I want to delete the first sheet and replace it with an identical sheet (identical in every sense, ie sheet name, data type in…
George Terziev
  • 129
  • 1
  • 3
  • 14
5
votes
1 answer

#NAME with module and function of the same name

I created a module called foo in my spreadsheet, and then I added the following to it: Function foo() As Variant foo = 5 End Function When I try to run the function in Excel, by typing =foo() into a cell, I get #NAME. When I look at what #NAME…
quant
  • 21,507
  • 32
  • 115
  • 211
5
votes
1 answer

VBA Editor broken - Excel 2016 OSX

I recently installed Excel 2016 for mac and when I launched the VBA editor the text was placed in a vertical way (line without any width) as shown in the following image. Any workaround for this?
bergercookie
  • 2,542
  • 1
  • 30
  • 38
5
votes
8 answers

Can't find Microsoft Forms 2.0 Object Library or FM20.DLL

In my Excel 2016 project (Windows 7), I'd like to work with the clipboard: Dim DataObj As New MSForms.DataObject DataObj.GetFromClipboard But I've got this compiler Error at the first line of code: User-defined type not defined So I would like to…
Lime
  • 13,400
  • 11
  • 56
  • 88
4
votes
2 answers

How to find a specific data of consecutive numbers inside an excel spreadsheet column

Please help me to find sequence of numbers present in column of a spreadsheet. I have a large data of 1's and 0's in an excel column, I need to find the sequence of consecutive 1's and 0's in the column. For example, my excel column is given…
Aashiq Shajahan
  • 55
  • 5
4
votes
4 answers

How to get first significant figure from a number in Excel?

I have a column of numbers in Excel 2016. The numbers span many orders of magnitude, but are all positive. Some are less than zero. How can I return the first significant figure of each cell in a new column? For example, for the number 1.9 the…
indigochild
  • 350
  • 1
  • 5
  • 21
4
votes
1 answer

Power Query Applying a Function Across Every Column

I am trying to write a query that takes a table and multiplies every number in the table by 100. I've gotten close, but I am having trouble applying it correctly to every column. Below is the code I have so far. The line starting with…
Zoopzoop
  • 43
  • 4
4
votes
1 answer

Adjusting the size of the textbox holding the charttitle

I have a bunch of charts in which the chart-title just doesn't fit on one line in the title-box. Rather than reducing the font size further, I'd prefer to make the textbox a little wider. Printing the current width of the charttitle to the…
eirikdaude
  • 3,106
  • 6
  • 25
  • 50
4
votes
2 answers

How do I prevent Excel VBA error: An unhandled win32 exception occurred in EXCEL.EXE [14756]

The client I'm working for recently upgraded all laptops to Microsoft Surface running windows 10 (version 10.0.16299) and Office 2016: Microsoft Excel 2016 MSO (16.0.9126.2295) 64-bit Microsoft Office 365 ProPlus I'm working on an Excel VBA…
Frozbie
  • 51
  • 1
  • 7
1
2
3
…
99 100