Release Notes - Windows Insider Fast (9/28)

September 28, 2018 Version 1810 (build 10920.20003)

What's new

Excel

Ideas in Excel
Discover more about your data.  Ideas looks for patterns in your data that it can use to create intelligent, personalized, suggestions.

Ideas for Excel makes it easier to analyze data and create interesting visualization as well as helping discover different perspectives on users’ data.

  1. Open Excel on Win32

  2. Open a spreadsheet with clean tabular data in the grid

  3. Find the Ideas button in the Home tab

  4. Run Ideas!

Scenarios to Try:

Open Ideas on any tabular dataset and see what recommendations are shown.

Excel

Dynamic array support

With dynamic arrays you can write a single formula that returns a list of values. One formula, many values. And because Excel’s grid now understands arrays, we’ve added amazing new functions that work with lists. So, for instance, you can use the SORT function to sort a list, the UNIQUE function to remove duplicates from a list, the FILTER function to extract an interesting subset from a list. And when your data changes, the dynamic array will resize and recalculate on the fly.

Getting Started:

  • Type some numbers in cell A1 through A10

  • In cell B1 type =SORT(A1:A10)


Notable fixes

In the table below, you'll find key fixes in the latest Insider build. 

Word

  • Various performance and stability fixes

Excel

  • We fixed an “Upload Blocked” error message that occurred with automatic saving

  • We fixed a crashing issue with changing from a Pivot to Pie Chart

PowerPoint

  • We fixed an issue with copy & paste of slides

Outlook

  • We fixed an issue with Focused Inbox

Access

  • We fixed an issue with refreshing SQL views in the new linked table manager

Project

  • We fixed a crashing issue with using AutoFilter in Team planner

 

Discussion Info


Last updated November 12, 2018 Views 286 Applies to:

new excel functions (build 1810) are not working in French

note translation is wrong as TRI (for sort) is already existing (financial function)

what are the right functions newly implemented ?

jhbf

Hi,

I am on Windows Insider (Fast), and have Excel for Office 365 MSO 16.0.10927.20000) on my laptop. 

Ideas feature is present and working fine (impressive actually).

But the 'dynamic arrays' (SORT(), UNIQUE() etc is not present. I cannot write a formula =SORT(A1:A10) or similar as suggested. SORT (and UNIQUE etc) are simply not recognised. 

Do I need to do something special for this ? 

I seem to have a similar problem.

Today (9.Oct) I got a further O365 update.

I'm now on 16.0.11005.20000 and still no sign of the dynamic array functions to show up. 

Dynamic Arrays are still rolling out, but are not yet available to 100% of users in Insiders Fast. More users will see it as they continue to roll it out.

-Jesse

Thabks for the reply Jesse. Guess some patience is called for. Hard when this is the most interesting Excel feature I can rem in last 20 years ! 

Any clues on timeline ?