• Skip to main content
  • Skip to primary sidebar
  • Skip to footer

Microsoft Excel Tips and Tricks - Computergaga

  • Home
  • Excel Online Courses
  • Excel Functions List
  • Free Downloads
  • Blog
  • Tutorials
  • About
Home / Office / How to Change to the Office 365 Monthly Update Channel

How to Change to the Office 365 Monthly Update Channel

Dynamic arrays have been rolled out to Office 365 users that are on the monthly channel updates.

Joe McDaid tweet on dynamic array formulas

Unfortunately, this means that if you are not on it, you will not have these (or other incredible updates) yet.

Do you know what update channel you are on?

If not, you can check this by clicking File > Account and viewing your product information on the right.

Checking your Office 365 ProPlus update channel

If you are on the Semi-Annual update channel you will not have dynamic arrays yet.

So let’s look at how to switch to the monthly update channel.

You will need Administrator privileges to perform these steps.

Please consult your IT department at your workplace. These steps can only be followed on your personal machine.

Click Start, and begin to type Registry. The Registry Editor should appear as an option from the search.

Opening the Registry Editor

You can also open the Registry Editor by using the Run command and typing regedit in the Run command box.

The Registry Editor window opens.

Note: I cannot take print screens whilst in the Registry Editor so I can only use text instructions here.

Navigate using the hierarchy structure on the left to the following path.

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration

Double click the CDNBaseUrl option to open the window.

If you are on the Semi-Annual channel then the following url will be in the Value data box – http://officecdn.microsoft.com/pr/7ffbc6bf-bc32-4f92-8982-f9dd17fd3114

Copy the following Url for the Monthly update channel and paste this into the Value data box instead – http://officecdn.microsoft.com/pr/492350f6-3a01-4f97-b9c0-c7c6ddf67d60

Click Ok and close the Registry Editor.

Start Excel and run the updates by click File > Account > Update Options > Update Now.

Running the Office 365 Updates

This will force the updates and when Excel restarts, you should have dynamic arrays.

You will also receive future updates nice and quick.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Popular Posts

  • Excel Fixtures and League Table Generator
  • 5 Reasons Why your Excel Formula is Not Calculating
  • Excel IF Function Contains Text – A Partial Match in a Cell
  • Excel Formula to Display the Sheet Name in a Cell
  • 4 Alternatives to Nested IF Formulas
  • How to Hyperlink to a Hidden Worksheet in Excel
  • How to Create a Reverse FIND Formula
  • Check if a Value is an Even Number
  • IF Function in Power Query Including Nested IFS
  • Conditional Formatting Multiple Columns – 3 Examples

Recent Posts

  • SEQUENCE Function in Excel
  • Sort by Drop Down List in Excel
  • Advanced SUM Function Examples – The Power of SUM
  • Display Negative Time in Excel
  • Lookup Multiple Values in Excel
Advanced Excel Success book

Footer

Contact

[email protected]

Useful Links

  • Home
  • Excel Online Courses
  • Tutorials
  • Sitemap
  • Privacy Policy
  • Jobs by Jooble

Course Topics

  • Charts
  • Courses
  • Dashboards
  • Downloads
  • Excel Tips
  • Formulas
  • Mail Merge
  • Office
  • PivotTables
  • Power BI
  • Power Pivot
  • Power Query
  • VBA

Join Our Mailing List

© Copyright 2020 Computergaga · All Rights Reserved ·