Skip to main content
insightsoftware Docs insightsoftware Docs
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

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 365 Monthly or Semi-Annual (Targeted) update channels...

channel01.png

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 Process

Detailed information about how to change your Microsoft 365 Update Channel is also available from Microsoft .

  1. Start a Command Prompt window (as Administrator)

  2. Change to the folder where Microsoft 365 stores its support files:

    cd C:\Program Files\Common Files\Microsoft Shared\ClickToRun
  3. Switch Microsoft 365 to the Semi-Annual ("Broad") Channel:

    OfficeC2RClient.exe /changesetting Channel=Broad
  4. 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...

channel02.png

All Update Channels provide monthly security updates

Published:

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 365 Monthly or Semi-Annual (Targeted) update channels...

channel01.png

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 Process

Detailed information about how to change your Microsoft 365 Update Channel is also available from Microsoft .

  1. Start a Command Prompt window (as Administrator)

  2. Change to the folder where Microsoft 365 stores its support files:

    cd C:\Program Files\Common Files\Microsoft Shared\ClickToRun
  3. Switch Microsoft 365 to the Semi-Annual ("Broad") Channel:

    OfficeC2RClient.exe /changesetting Channel=Broad
  4. 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...

channel02.png

All Update Channels provide monthly security updates

For an optimal Community experience, Please view on Desktop