This article describes update 4484437 for Microsoft Excel 2016 that was released on July 7, 2020. Be aware that the update in the Microsoft Download Center applies to the Microsoft Installer (.msi)-based edition of Office 2016. Download microsoft office excel 2016 for free. Office Tools downloads - Microsoft Office Excel by Microsoft and many more programs are available for instant and free download. Auto update a chart after entering new data with creating a table. If you have the following range of data and column chart, now you want the chart update automatically when you enter new information. In Excel 2007, 2010 or 2013, you can create a table to expand the data range, and the chart will update.
-->Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Symptoms
By default, installations of Microsoft Office are configured to automatically update your Office installation when new updates are made publicly available. However, if you examine the Account section of the backstage, you may see that updates are disabled or that the command to manage updates is disabled or hidden. For example, the following figure indicates that updates are disabled in the backstage.
Cause
This issue occurs if updates have been manually disable or are managed through Group Policy settings.
Resolution
We recommend that you keep automatic updating enabled for Office installations because this configuration allows Office to automatically update with the latest fixes and security features. To re-enable automatic updates for Office, follow the steps below.
How to save preview as pdf. Manually configure automatic updates
If your Office installation is not managed by Group Policy, you can manually re-enable automatic updates by following these steps. If you cannot follow these steps because the Update Options control is disabled or missing, your updates are being managed by Group Policy.
- Start any program.
- On the File tab, select Account.
Note: In Outlook, select Office Account. - On the right side, select Update Options, and then select Enable Updates.
- If you are asked whether you want to let Microsoft Office make changes to your computer, select Yes.
Automatic updates managed by Group Policy
Warning
Follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur.
If you cannot follow the steps in the 'Manually configure automatic updates' section, this is because the Update Options control is disabled or missing due to a Group Policy. For example, the following figure shows the Update Options control when the Enable Updates option is hidden through a Group Policy:
To examine the registry data that is associated with the Group Policy settings which control this feature, follow these steps:
- Start Registry Editor. To do this, take one of the following actions:
- In Windows 10 or Windows 8, press the Windows key + X, select Run, type regedit in the Open box, and then press Enter.
- In Windows 7 and Windows Vista, select Start, type regedit in the Start Search box, and then press Enter. If you are prompted for an administrator password or for confirmation, type the password, or select Allow.
- Locate and then select the following registry key:
Note: If this key does not exist in your Registry Editor, see How to add the registry key via policy below.
Microsoft 365 Apps for enterprise, Office 2019, and Office 2016
HKEY_LOCAL_MACHINEsoftwarepoliciesmicrosoftoffice16.0commonOfficeUpdate
How to search appdata. Office 2013
HKEY_LOCAL_MACHINEsoftwareWow6432Nodemicrosoftoffice15.0commonOfficeUpdate
- Examine the following registry values under the OfficeUpdate key:
- DWORD: EnableAutomaticUpdates
Values:
0 = automatic updates are disabled
1 = automatic updates are enabled - DWORD: HideEnableDisableUpdates
Values:
1 = hide the menu option to enable or disable automatic updates
0 = show the menu option to enable or disable automatic updates
- If you have any questions or concerns about these policy settings, see your domain administrator.
How to add the registry key via policy
How To Update Excel 2016 To 2019
The registry key is added automatically when you install ADMX/ADML files. To do this:
Microsoft 365 Apps for enterprise, Office 2019, and Office 2016
- Always download the LATEST admin templates to a location of your choice:Administrative Template files (ADMX/ADML) and Office Customization Tool for Microsoft 365 Apps for enterprise, Office 2019, and Office 2016
- Select the Download button.
- Select either the x64 or the x86 build.
- Select Run and follow the prompts to install the software.
- Copy the *.admx files into the C:/Windows/PolicyDefinitions/ folder.
- Copy the *.adml files from the language-locale subfolder (for instance, 'en-US') into the respective language-locale folder under C:/Windows/PolicyDefinitions/.
Warning
Be sure to preserve the same language-locale PolicyDefinitions folder which is applicable to your environment.
Office 2013
- Go to the Office 2013 Administrative Template files (ADMX/ADML) and Office Customization Tool page.
- Select the Download button.
- Select either the x64 or the x86 build.
- Select Run and follow the prompts to install the software.
- Copy the *.admx files into the C:/Windows/PolicyDefinitions/ folder.
- Copy the *.adml files from the language-locale subfolder (for instance, 'en-US') into the respective language-locale folder under C:/Windows/PolicyDefinitions/.
Warning
Be sure to preserve the same language-locale PolicyDefinitions folder which is applicable to your environment.
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
Symptoms
By default, installations of Microsoft Office are configured to automatically update your Office installation when new updates are made publicly available. However, if you examine the Account section of the backstage, you may see that updates are disabled or that the command to manage updates is disabled or hidden. For example, the following figure indicates that updates are disabled in the backstage.
Cause
This issue occurs if updates have been manually disable or are managed through Group Policy settings.
Resolution
We recommend that you keep automatic updating enabled for Office installations because this configuration allows Office to automatically update with the latest fixes and security features. To re-enable automatic updates for Office, follow the steps below.
How to save preview as pdf. Manually configure automatic updates
If your Office installation is not managed by Group Policy, you can manually re-enable automatic updates by following these steps. If you cannot follow these steps because the Update Options control is disabled or missing, your updates are being managed by Group Policy.
- Start any program.
- On the File tab, select Account.
Note: In Outlook, select Office Account. - On the right side, select Update Options, and then select Enable Updates.
- If you are asked whether you want to let Microsoft Office make changes to your computer, select Yes.
Automatic updates managed by Group Policy
Warning
Follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur.
If you cannot follow the steps in the 'Manually configure automatic updates' section, this is because the Update Options control is disabled or missing due to a Group Policy. For example, the following figure shows the Update Options control when the Enable Updates option is hidden through a Group Policy:
To examine the registry data that is associated with the Group Policy settings which control this feature, follow these steps:
- Start Registry Editor. To do this, take one of the following actions:
- In Windows 10 or Windows 8, press the Windows key + X, select Run, type regedit in the Open box, and then press Enter.
- In Windows 7 and Windows Vista, select Start, type regedit in the Start Search box, and then press Enter. If you are prompted for an administrator password or for confirmation, type the password, or select Allow.
- Locate and then select the following registry key:
Note: If this key does not exist in your Registry Editor, see How to add the registry key via policy below.
Microsoft 365 Apps for enterprise, Office 2019, and Office 2016
HKEY_LOCAL_MACHINEsoftwarepoliciesmicrosoftoffice16.0commonOfficeUpdate
How to search appdata. Office 2013
HKEY_LOCAL_MACHINEsoftwareWow6432Nodemicrosoftoffice15.0commonOfficeUpdate
- Examine the following registry values under the OfficeUpdate key:
- DWORD: EnableAutomaticUpdates
Values:
0 = automatic updates are disabled
1 = automatic updates are enabled - DWORD: HideEnableDisableUpdates
Values:
1 = hide the menu option to enable or disable automatic updates
0 = show the menu option to enable or disable automatic updates
- If you have any questions or concerns about these policy settings, see your domain administrator.
How to add the registry key via policy
How To Update Excel 2016 To 2019
The registry key is added automatically when you install ADMX/ADML files. To do this:
Microsoft 365 Apps for enterprise, Office 2019, and Office 2016
- Always download the LATEST admin templates to a location of your choice:Administrative Template files (ADMX/ADML) and Office Customization Tool for Microsoft 365 Apps for enterprise, Office 2019, and Office 2016
- Select the Download button.
- Select either the x64 or the x86 build.
- Select Run and follow the prompts to install the software.
- Copy the *.admx files into the C:/Windows/PolicyDefinitions/ folder.
- Copy the *.adml files from the language-locale subfolder (for instance, 'en-US') into the respective language-locale folder under C:/Windows/PolicyDefinitions/.
Warning
Be sure to preserve the same language-locale PolicyDefinitions folder which is applicable to your environment.
Office 2013
- Go to the Office 2013 Administrative Template files (ADMX/ADML) and Office Customization Tool page.
- Select the Download button.
- Select either the x64 or the x86 build.
- Select Run and follow the prompts to install the software.
- Copy the *.admx files into the C:/Windows/PolicyDefinitions/ folder.
- Copy the *.adml files from the language-locale subfolder (for instance, 'en-US') into the respective language-locale folder under C:/Windows/PolicyDefinitions/.
Warning
Be sure to preserve the same language-locale PolicyDefinitions folder which is applicable to your environment.
After you copy the Administrative Template files to AD DS, you'll find the update policy settings under Computer Configuration > Policies > Administrative Templates > Microsoft Office 2016 (Machine) > Updates in the Group Policy Management Console. You'll also find a description of how to configure each policy setting.
More information
How To Update Excel 2016 To Latest Version
For more information about configuring the update settings via GPO, see Configure update settings for Microsoft 365 Apps for enterprise.
