The latest release of Excel 365 for Windows is a right mess with missing Dynamic Arrays and, for a while, Stock and Geography data types disappeared too! We received some reports late Friday, US time that Excel 365 for Windows v1907 build 11901.20176 wasn’t showing Stock or Geography data types on the Data ribbon. The […]
It’s quite easy to tell if your Excel 365 has the new Dynamic Arrays. No need to setup a table and use the new feature – just three keypresses are enough. Some people are reporting that they have the right Excel 365 but with no dynamic arrays. Checking the program/app version is possible, see below. […]
Microsoft says that Dynamic Arrays have arrived but Excel 365 users beg to differ. Despite the company’s written assurances, the promised feature is nowhere to be seen. Plenty of reports that Excel 365 for Windows version 1907 (Build 11901.20176) does not have the important new feature Microsoft says it should. What’s new in Office 365 […]
After many months of testing, all Excel 365 apps now have dynamic arrays (except Excel Online) though some are just for Insiders at present. Dynamic Arrays are a major and powerful expansion of Excel’s powers. The new abilities, functions and error messages might seem scary but are a great leap forward for Excel. All Excel […]
A new option in Office 365 for Windows is the ability to choose how hyperlinked Office files are opened. Inside Word, Excel or PowerPoint or in the default browser. The new option is at File | Options | Advanced | Link Handling Open supported hyperlinks to Office files in Office desktop apps. An Office document […]
