Windows 10: New STOCKHISTORY feature in Excel for Microsoft 365

Brink · Jun 10, 2020

Disclaimer
STOCKHISTORY is currently available to 50% of Microsoft 365 Subscribers in the Beta level of the Office Insider program. The behavior and signature of this function is subject to change. Releasing this way allows us to get early feedback to prepare for a broader release. This function will only be available to Microsoft 365 customers who are signed in.

Excel is introducing a dynamically updating service-backed function that builds on the flexibility of dynamic arrays and fills a gap in the Stocks data type by providing access to historical data.

We have added many needed improvements to support service-side errors and data retrieval, including new errors like #BUSY! that show in Excel while data is being processed. We also added a way for the function to spill formats dynamically instead of stamping a format on a cell.

Introducing STOCKHISTORY

Easily pulling stock prices into Excel has been one of the most requested features on UserVoice. The Stocks data type began this journey by enabling refreshable quotes for stocks, bonds, funds, and currency pairs. We know that this wasnât enough to complete the goals you have for analyzing your portfolio in Excel. Getting the history of a financial instrument over time is crucial information you need. We are thrilled to be able to bring this functionality into Excel.
Click to expand...

Read more: https://techcommunity.microsoft.com/...y/ba-p/1404338

:)

Brink · Jun 10, 2020

What is New with Microsoft 365 in February 2020

Welcome to the latest edition of What’s New with Microsoft 365. This monthly video series will help you to better understand the new features and functionality coming to Microsoft 365 as well as features to support your end-users. Each episode will also provide interviews with the product teams that worked directly on the features so you can better understand how and why these features have come to the product.

In our latest episode, we cover:

New custom search capabilities for SharePoint Online -

Office “What’s New” management - Roadmap ID 60010

FastTrack support for Microsoft Edge

Native Mode and eDiscovery in Yammer communities - Roadmap ID: 50555

Yammer file uploads to Office 365-connected groups - Roadmap ID: 26821

Create Visio drawings in Microsoft Teams

Note: Your organization must have a Visio Online Plan 1 or Plan 2 subscription.

Real-time collaboration in Visio for the web

Note: Your organization must have a Visio Online Plan 1 or Plan 2 subscription.

German datacenter regions

Dark Mode in OneNote for Android

Inking in OneNote for Android

-“What’s New with Microsoft 365” video team
Click to expand...

Source: https://techcommunity.microsoft.com/...5/ba-p/1231418

dalchina · Jun 10, 2020

CSV files used to open in Excel....not now!

Hi, you say Excel is installed. Does it run normally?

You can't find Excel in (an unspecified) list of applications. I don't know which list that is for sure.

For example, in the list related to:
- rt click a file. Open With
- this list:

- this list:

- some other list...

If Excel does not appear in the above, I suggest you repair your office installation.

Maybe the above gives you some ideas. Otherwise please post a screenshot of where you think you should see it but don't. Thanks.

Brink · Jun 10, 2020

New feature updates for Power Pivot in Excel 2016

We are pleased to announce new feature updates to Power Pivot for Excel 2016 as part of your Office 365 subscription. These updates include the ability to save a relationship diagram view as a picture and enhancements to the relationship dialog experience. We also fixed a number of important bugs to improve your overall modeling user experience.

Save relationship diagram view as picture

Excel 2016 users can now save the data model diagram view as a high resolution image file that can then be used for sharing, printing or analyzing the data model. To create the image file, in the Power Pivot add-in, click File and then select Save View as Picture.

Enhanced Edit Relationship dialog creates faster and more accurate data relationships

Excel 2016 Power Pivot users can now manually add or edit a table relationship while exploring a sample of the data—up to five rows of data in a selected table. This helps create faster and more accurate relationships without the need to go back and forth to the data view every time you wish to create or edit a table relationship.

We have also added several usability goodies to the Edit Relationship dialog:

Table selection using keyboard navigation—Type the first letter of a table name to move the first column name starting with the selected letter.

Column selection using column navigation—Type the first letter of a column name to move the first column starting with the selected letter. Retype the same letter moves to the next column starting with the selected letter.

Auto column suggestion for same column name in both tables—After selecting the first table and column, on the selection of the second table, if a column with the same name exists, it is auto-selected (works both ways).

Fixes that improve your overall modeling user experience

We made a few fixes that improve your modeling user experience, including:

Power Pivot data model is no longer lost when working with hidden workbooks.

Ability to upgrade an Excel 2010 workbook with a data model to Excel 2016 is now available.

Ability to add a calculated column in Power Pivot, unless it contains a formula, is now available.

For a full list in this customer update, visit Power Pivot and the Analysis Services Engine in Excel 2016 fixes.

For all Excel 2016 users, get the latest customer update by installing the following updates. Note, there are 32- and 64-bit versions of each, so be sure to download the right version:

KB3114374—Office 2016 Excel update from December 8, 2015.

KB3114297—Office 2016 Power Pivot in Excel from December 8, 2015.

Try them yourself!

Try these new improvements and see how they can help you improve your analysis performance. Do you have ideas on other improvements that you’d like to see in Excel? Visit the Excel UserVoice and tell us about them.
Click to expand...

Source: New feature updates for Power Pivot in Excel 2016 - Office Blogs

Windows 10: New STOCKHISTORY feature in Excel for Microsoft 365

New STOCKHISTORY feature in Excel for Microsoft 365

New STOCKHISTORY feature in Excel for Microsoft 365

New STOCKHISTORY feature in Excel for Microsoft 365

New STOCKHISTORY feature in Excel for Microsoft 365 - Similar Threads - STOCKHISTORY feature Excel

Excel stockhistory function malfunction

Excel stockhistory function malfunction

Excel stockhistory function malfunction

Microsoft announces new features for Microsoft 365 mobile apps

Excel 365

New Rewrite feature in Microsoft Word for Office 365

New Sketchy Shapes feature for Office 365 Word, PowerPoint, and Excel

New Data Types in Excel for Office 365

New security features for Microsoft 365 Business