Changing Your Microsoft Office Update Channel
Overview
When refreshing reports with the Jet Excel Add-In, some installations of Microsoft Excel can experience slow performance, crashes, and memory issues. Generally when this occurs without having changed anything in your Jet Reports environment there may be an issue with the latest Current channel update for Microsoft 365.
More information about the Microsoft 365 update channels is available from Microsoft.
Resolution: It is easy to adjust the update channel used by your Microsoft 365 subscription and install the latest corresponding update to see if the issues are related to update channel you were using.
Resolution Process
Detailed information about how to change your Microsoft 365 update channel is also available from Microsoft.
-
Start a Command Prompt window (as Administrator).
-
Change to the folder where Microsoft 365 stores its support files:
cd C:\Program Files\Common Files\Microsoft Shared\ClickToRun
-
Switch Microsoft 365 to the Semi-Annual ("Broad") channel:
OfficeC2RClient.exe /changesetting Channel=SemiAnnual
Note: To change back to the Current ("Monthly") channel:
OfficeC2RClient.exe /changesetting Channel=Monthly
-
Update the installation of Microsoft 365:
OfficeC2RClient.exe /update user
Once that process completes, Microsoft 365 will be configured for the Semi-Annual update channel...