Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.
Great news for Mac Office 365 users, the Stock and Geography data types in Excel 365 for Windows have started rolling out to Excel 365 for Mac.
At the moment it’s only Excel 365 for Mac, Fast Insiders v16.22 build 190112 or later. It means it’s coming to Slow Insiders and Office 365 customers generally in the coming months.
Stock Prices and financial info
The latest Stock price and other financial information can go directly into Excel 365 for Mac. Excel 365 for Windows worksheets with Stock data open and work immediately in Excel 365 for Mac.
Here’s a sample stock price and info worksheet that all our Real-Time Excel ebook customers have. The workbook was made in Excel 365 for Windows but now opens and updates prices in Excel 365 for Mac.
Have you got Stock and Data types?
To see if your Excel 365 (Office 365 customers only) has this feature, go to the Data tab and look for the new section with Stocks and Geography icons.
Because it’s an external link, these Linked Data Types come with a standard security warning. Click Enable Content to allow Linked Data Types to update.
It’s the same for Geographical info. Country, region, city and town data can be added and updated. Here’s another Real-Time Excel worksheet working in Excel 365 for Mac.
More good news is that the Geography data team have done a lot of work normalizing and fixing the data. The more obvious errors are being fixed (e.g. Official Name and Official Language) and some fields removed because the values aren’t reliable (Date Founded).
The important Sortby() function is also available. Sortby()automatically re-sorts a table each time the sheet is recalculated without VBA.
It uses SortBy() to make a table in the order you want as the values change. When we opened this workbook, Apple was at the top according to Dec 2018 values. The prices were updated and Sortby() kicked in to put Amazon at the top and Apple down at a lowly fourth place.
Seems simple but until now, automatic table sorting could only be done via VBA.
Real-Time Excel explains how to auto-sort tables in VBA (for those without Excel 365) and the above Sortby() example.
Office Watch has the latest news and tips about Microsoft Office. Independent since 1996. Delivered once a week.