Microsoft Excel: Upgrade to the latest Excel features
By J. Carlton Collins, CPA
Q. I am an Office 365 subscriber using Excel 2016. Is it possible for me to install and use the latest beta version of Excel 2019?
A. I received your question before Office 2019 was made generally available, but I think the answer is still of use moving forward. The days of downloading and installing the prerelease beta version of Microsoft Excel are gone, but you can still install the latest prerelease beta features for free, as follows. First, you must be an Office 365 subscriber of Microsoft Excel. If you are, then you can install the latest available features from the Excel menu by selecting File, Account, Office Insider, Change Level, then selecting Insider from the Choose your Office Insider level dropdown menu, as pictured below, and clicking OK.
Thereafter, Excel will update your product approximately weekly with the latest prerelease beta features. (Be aware that by making this change, you will be accepting the higher risk involved in using unsupported builds of the Excel product — which in my experience means Excel may occasionally restart, freeze, or crash, but data loss or computer damage has not been an issue. Also, be aware that by becoming an Office Insider in this manner, you are agreeing to allow Microsoft to collect various diagnostic and error reporting data from your computer.) Once this process is complete, you can select File, Account, Update Options, Update Now to make sure the latest prerelease beta updates are installed immediately. Once this update is completed, you will be effectively using Excel's latest beta version.