Reports Running Slowly in Excel 2016
Overview
When refreshing Jet Reports, some installations of Excel 2016 can experience slow performance and memory issues. As of the writing of this information, there is an issue with certain versions of Excel 2016 which are updated through the Microsoft 365Monthly or Semi-Annual (Targeted) update channels.
More information about the Microsoft 365 Update Channels is available from Microsoft.
Resolution
insightsoftware is working to define this issue with Microsoft so that it can be addressed in an upcoming Microsoft 365 update. In the meantime, it is easy to adjust the Microsoft Update Channel used by your 365 subscription so that a supported version of Excel is installed.
Note: All Microsoft 365 Update Channels provide monthly security updates.
Additional Information
The following table provides information about how often each Microsoft Channel usually includes feature updates, security update, and non-security updates. The Jet Excel add-in supports the Semi-Annual Channel.
| Update Channel | Feature Updates | Security Updates | Non-security Updates |
|---|---|---|---|
| Semi-Annual Channel * | Every six months (Jan & July) | Monthly | Every six months |
| Semi-Annual Channel (Targeted) | Every six months (Mar & Sept) | Monthly | Monthly |
| Monthly | Monthly | Monthly | Monthly |
|
* Supported Update Channel More information about Microsoft Update Channels is available from: https://docs.microsoft.com/en-us/deployoffice/overview-of-update-channels-for-office-365-proplus |
Currently, insightsoftware officially supports only the use of the Semi-Annual Update Channel.
According to Microsoft
The Monthly Update Channel is suitable for those organizations which don't have many line-of-business applications, add-ins, or macros that you need to test to determine if they work with an updated version of Office.
The primary purpose of the Semi-Annual (Targeted) Update Channel is to give pilot users and application compatibility testers in your organization a chance to work with the upcoming Semi-Annual Channel release. During this time, which is about four months, you might identify possible issues that you need to fix with your line-of-business applications, add-ins, or macros or that you want Microsoft to fix.
Resolution
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=Broad
-
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...
All Update Channels provide monthly security updates.