Описание обновления для системы безопасности Office 2016 г.: 11 мая 2021 г. (KB4493197)
Это обновление для системы безопасности устраняет уязвимость удаленного выполнения кода Microsoft Access. Дополнительные информацию об уязвимости см. в записи Распространенные уязвимости и уязвимости в CVE-2021–28455 корпорации Майкрософт.
Примечание: Чтобы применить это обновление для системы безопасности, на компьютере должна быть установлена версия Выпуска Microsoft Office 2016.
Следует помнить, что обновление в Центре загрузки Майкрософт относится к установщику Microsoft (.msi)Office 2016. Она не относится к версиям Office 2016 нажми и работы, таким как Microsoft Office 365 для дома (см. какую версию Office я использую?).
Как получить и установить обновление
Способ 1. Обновление Майкрософт
Это обновление доступно в Обновлении Майкрософт. Когда вы включите автоматическое обновление, это обновление будет скачиваться и устанавливаться автоматически. Дополнительные сведения об автоматическом обновлении для системы безопасности см. в обновлении Windows: faq.
Способ 2. Каталог обновлений Майкрософт
Чтобы получить автономный пакет для этого обновления, перейдите на веб-сайт каталога обновлений Майкрософт.
Способ 3. Центр загрузки Майкрософт
Вы можете получить пакет автономных обновлений через Центр загрузки Майкрософт. Следуйте инструкциям по установке на странице скачивания, чтобы установить обновление.
Дополнительная информация
Сведения о развертывании обновлений для системы безопасности
Сведения об этом обновлении см. в сведениях о развертывании обновления для системы безопасности: 11 мая 2021 г.
Сведения об обновлении системы безопасности для замены
Это обновление системы безопасности заменяет ранее выпущенное обновление для системы безопасности 4486755.
Security update for microsoft office что это
ВРЕДНЫЕ ОБНОВЛЕНИЯ ОТ MICROSOFT
Вызывает сожаление, что такой разработчик программного обеспечения, как Microsoft в погоне за прибылью совершенно не заботится о своих потребителях. Они все чаще и чаще выпускают в обращение новое ПО, которое не прошло полного тестирования и потом вызывает проблемы с эксплуатацией компьютерной техники. Сейчас даже пользователи лицензионных программ от Microsoft не защищены от ляпов, которые допускают программисты этой компании. Многие наверняка уже сталкивались с ситуацией, когда после установки обновлений для Windows 7, 8 или программ Office различной модификации компьютеры перестают нормально работать. Лично я сталкивался с ситуациями, когда после обновления ПО разрешение мониторов на ноутбуках становилось нестандартным и не поддавалось настройке обычными методами, когда переставало работать подключенное к компьютеру внешнее оборудование, когда некоторыми программами из комплекта Office 2010 было невозможно пользоваться. В последнее время я все больше и больше убеждаюсь, что основное достоинство лицензионного ПО от Microsoft – возможность постоянного обновления — становится недостатком.
В статье «Война Microsoft с конкурентами или результаты действия обновления KB915597», я уже частично касался темы о вредных обновлениях от Microsoft. Конечно, там описывался случай, когда компания Microsoft намеренно не тестирует совместимость своего ПО с изделиями сторонних разработчиков, а те, в свою очередь, даже не думают выпускать новые драйверы и программы для своего оборудования, которые бы обеспечивали устойчивую работу с новыми программами от Microsoft. Но сейчас компания Microsoft вообще превзошла саму себя. Т.е. в том случае речь шла о несовместимости нового ПО от Microsoft и других производителей. Теперь же предлагаю ознакомиться с побочными эффектами, вызванными обновлениями КВ3023266, КВ3022777, КВ2910902 и КВ2881071.
Начнем все по порядку. Как-то давно у меня перестала работать мышь, которая подключалась к компьютеру через порт PS/2. Тогда я только чертыхнулся, купил новую мышь с USB разъемом и стал ей пользоваться. Мало ли что бывает. Техника есть техника, и даже мыши могут отказывать. Каково же было мое удивление, когда я через некоторое время проверил работоспособность старой мыши на другом компьютере. Она оказалась полностью рабочей. Все стало ясно, просто одно из многочисленных обновлений, разработанных в лабораториях Microsoft, отключило порт PS/2 для мыши. Но, т.к. уже прошло некоторое время после того, как я заменил мышь, искать виновника посчитал нецелесообразным.
Теперь уже не так давно при попытке включить компьютер я обнаружил, что подобная описанной выше проблема появилась снова, но уже с клавиатурой, которая так же подключалась к системному блоку через разъем PS/2. Данная проблема оказалась более серьезной, чем предыдущая. Дело в том, что без клавиатуры невозможно инициировать свою учетную запись и, тем более, откатить систему до работоспособного состояния. Пришлось, как и в предыдущий раз, воспользоваться устройством (в данном случае клавиатурой) с разъемом USB.
После того, как удалось запустить систему и провести анализ установленных обновлений, выяснилось, что удаление обновлений КВ3023266 и КВ3022777 позволило вновь пользоваться старой клавиатурой. Что интересно — ни на официальном сайте Microsoft, ни на различных форумах я не нашел информации о данной проблеме.
Поиск обновлений, которые привели к отключению клавиатуры с разъемом PS/2, конечно, занял много времени, но больше всего мне пришлось повозиться с программой Office 2010, когда возникла необходимость проверить расчеты одного из элементов мебели. Я был неприятно удивлен, узнав, что с помощью обновлений КВ2910902 и КВ2881071 компания Microsoft внесла изменения в программу «Excel», после которых исчезла индикация введенных формул в строке формул таблицы «Excel». Т.е. при вводе расчетных формул в конкретную ячейку, их индикация есть. Но при попытке выполнить проверку содержания этой ячейки вы столкнетесь с трудностями.
На Рис.1 представлен внешний вид окна программы Excel, входящей в комплект Office профессиональный плюс 2010. Конечно, обозначение столбцов буквами (см.1 Рис.1) – не самый лучший вариант. Но при просмотре содержания ячеек, если в них присутствовала формула, эта формула отражается в строке отображения формул (см.3 Рис.1), а в самой ячейке (см.2 Рис.1) будет отображаться результат вычислений.
На Рис.2 отображено окно той же программы, что и в первом случае, но уже после установки обновлений КВ2910902 и КВ2881071. Конечно, то, что при обозначении столбцов применены цифры, а не буквы (см.1 Рис.2) – это удобно. Но на этом удобства заканчиваются. При попытке проверить содержание ячеек с введенными туда формулами в самой ячейке отображается результат расчетов, а в строке отображения формул вы увидите не очень понятное содержание (см. 3 Рис.2). Попытка все же узнать содержание формул с помощью кнопки «Посмотреть формулы» (см.1 Рис.3), тоже не сильно поможет. Вы получите не привычную информацию (см.2 и 3 Рис.3).
Столкнувшись с этой проблемой, любой пользователь, естественно, кинется на официальный сайт Microsoft, где попытается найти либо информацию о том, как сделать доступной индикацию содержимого ячеек в строке отображения формул, либо выяснить причину, по которой произошли изменения в программе Excel. Но по состоянию на 12.02.2015 г. там вы ничего не найдете. Поэтому пришлось самостоятельно искать виновников такого поведения программы, а ими оказались обновления Security update for Microsoft Excel (КВ2910902) и Security update for Microsoft Office 2010 (КВ2881071).
Не знаю как кому, а мне надоело «искать хвосты», которыми потчует компания Microsoft своих потребителей, невзирая на то, лицензионным или же не лицензионным программным обеспечением они пользуются. Поэтому я после удаления обновлений, приведших к ненормальной работе своего ПК, отключил автоматическую установку обновлений от Microsoft. Сам же процесс удаления обновлений описан в статье «Как удалить обновление, которое привело к неправильной работе ПК или оборудования».
К сожалению, о вредных обновлениях от Microsoft говорить можно много. Мне не раз приходилось сталкиваться с их проявлениями, но в последнее время их стало слишком много, и работники компании Microsoft не спешат публиковать информацию о возможных последствиях от распространяемого ими ПО. Остается только удивляться настойчивым призывам этой компании к использованию лицензионного ПО, если они не могут обеспечить его нормальную эксплуатацию потребителями. Кроме этого, удивляет и то, что с официального сайта Microsoft исчезли пробные версии их основных программ. Конечно, это их программы, и дело самой компании давать пользователям возможность тестировать их или нет. Но удобство использования программ этой компании в последнее время значительно снизилось.
Download and install Microsoft office 2016 update KB4493157 for January 2021
Microsoft has just released patch updates for Microsoft Office 2016, amongst other products including Microsoft Access 2016, Outlook 2016, and Project 2016. These updates are the first of 2021 as part of Office Patch Tuesday, the first Tuesday of every month.
This is a non-security update designed only for Microsoft Office 2016 that has been installed using MSI files, and not through Office 365. Let’s discuss what the new update has to offer, and whether it’s worth installing right away.
Microsoft Office 2016 Updates January 2021
Table of contents
- Microsoft Office 2016 Update KB4493157 for January 2021
- Improvement and fixes
- Download and install Microsoft Office 2016 update KB4493157
- Update for Microsoft Access 2016 KB4484509
- Update for Microsoft Outlook 2016 KB4493166
- Update for Microsoft Project 2016 KB4493159
Microsoft Office 2016 Update KB4493157 for January 2021
Improvement and fixes
This release was made primarily to enhance the user experience for Visual Basic for Applications (VBA). VBA is a programming language that was once derived from Visual Basic 6 which is primarily used by developers for building user-defined functions and automation purposes.
Download and install Microsoft Office 2016 update KB4493157
The update for Office 2016 KB4493157 released in January 2021 and can be installed by 2 means: through the Windows Updates and manually from the Microsoft Catalog.
You will need to have Microsoft Office 2016 installed on the machine when installing the standalone update. Moreover, you might have to reboot the computer once it is installed.
- Method 1:Installing through Windows Update
Navigate to the following:
Start Menu -> Settings -> <a href="https://www.itechtics.com/enable-windows-security-updates-over-metered-connections/">Update and Security -> Windows</a> update - Click on Check for updates on the right. Note that you will require an active internet connection at this stage. The computer will then search for any pending updates.
- Updates will now automatically download and install. Once done, reboot the computer.
- Method 2: Installing from Microsoft Catalog
Download the respective updates:-
[248.0 MB] [126.5 MB]
Other non-security updates for January 2021
As we mentioned earlier, other updates alongside Office 2016 have also been released by Microsoft. The updates include the following:
Update for Microsoft Access 2016 KB4484509
This update applies to Microsoft Access 2016, and can only be updated if it is preinstalled on your PC. The method to update is the same as Office 2016 stated above.
The update fixes an issue where the code running within the form in the main Access window is often not visible when the application is halted at a Stop statement or a VBA breakpoint. Moreover, it also improves the VBA experience by increasing its reliability.
Update for Microsoft Outlook 2016 KB4493166
This update fixes several important issues that the users have experienced for some time. It fixes an issue that causes Microsoft Outlook 2016 to often crash without a prompt. It also addresses the problem of users being unable to provide justification text when overriding a policy.
Another important feature it adds is a dedicated Key in the Windows Registry by the name “IncludeFileTimesInDataObject.” Setting its value to 1 would enable users to include file time for attachments, while setting it to 0 would disable the option to do so. This registry could be found on the following path within the Registry Editor:
Update for Microsoft Project 2016 KB4493159
This update addresses a single yet considerable issue in Project. The long pauses which the users experienced while editing texts within a project that had many tasks will no longer exist. Installing this update will enable users to view the text update on their screen while they are typing it.
Closing words
In our opinion, these updates are not significant and users can do fine just as well, especially since these are non-security updates. However, if they do get installed automatically through Windows Update, no harm is done. In fact, it is better to keep your PC and all of its applications up to date.
Security update for microsoft office что это
[last updated: May 9, 2023]
Introduction
The past years we have received several support requests that we found out were related to/caused by (often already fixed) bugs in Excel 2021/2019/2016/365.
This article shows information on how to update your Excel installation and also contains links to the Microsoft articles with all the detailed information about what has been fixed and improved by the Excel team.
How an error or crash in Excel may appear to be caused by ASAP Utilities, but is not
Unfortunately, several bugs were introduced in Excel and Excel’s VBA/macro language that could cause slow performance and crashes in Excel (1, 2, 3, 4, 5, 6, 7).
Since many users don’t use macros themselves, they may only experience such specific Excel bugs (slow speed/crashes) when they use an add-in, such as for example ASAP Utilities, that uses Excel’s built-in VBA/macro programming language for its tools and it then seems as if the add-in is faulty. In general, if something goes wrong in ASAP Utilities, you should get a polite error message. It should never make Excel crash.
Most of the times, just updating Excel will solve it already. If a fix isn’t available yet from Microsoft, then we try to create a workaround in ASAP Utilities to handle such Excel bugs, because we do not always know how long it will take the Excel team to fix it.
Fortunately Microsoft has already released many updates with fixes related to the performance and stability of Excel 2021/2019/2016/365.
Using Cisco Endpoint security and an old version of ASAP Utilities?
In case you are using Cisco Endpoint security and experience Excel crashing with an old version of ASAP Utilities, then please read the following and upgrade to version 7.8 or later:
# Changes in version 7.8 — November 3, 2020
https://www.asap-utilities.com/faq-questions-answers-detail.php?m=328
How to install Excel/Office updates
To update Excel/Office to the latest version available:
- Start Excel.
- Go to File > Account
- Under Product Information, choose Update Options > Update Now.
List of the latest Office Updates
Office 365 client update channel releases
On the following page you can see the most recent changes the the Office 365 products. It shows even the recent ones that don’t have their own update article yet on the Microsoft Support website. You can choose to only see the updates that impact Excel.
https://technet.microsoft.com/en-us/office/mt465751
https://support.office.com/en-us/article/Version-and-build-numbers-of-update-channel-releases-ae942449-1fca-4484-898b-a933ea23def7
Issues in Excel that Microsoft is aware of — with status updates
Excel 365 Issues resolved by Microsoft
- Version 2304: April 25, 2023
- We fixed an issue where a file could not be previewed in File Explorer if the file’s extension included a capital letter such as XLSX, or Xlsx.
- We fixed an issue where right clicking a folder in Outlook could cause Office applications to close unexpectedly.
- We fixed an issue where spaces were not inserted properly when inserting text with dictation.
- Pivot Tables connected to Power BI datasets now have proper date support. Previously, dates were treated as strings, but they now are treated as datetime objects that allow for proper filtering and sorting of the data. If you do not yet have the feature, you will be able edit your existing PivotTable.
- We fixed an issue where the File > Get Add-ins button hotkey had a conflict with the Save As button due to an incorrectly set keytip when opening the Control Get Add-ins button. The modified button (Get Add-ins) will use B as the hotkey.
- We fixed an issue that when clicking on an email notification with @mention in a comment, caused Excel to close unexpectedly if the workbook was already open and was in a hidden window.
- Pivot Tables connected to Power BI datasets now have proper date support. Previously, dates were treated as strings, but they now are treated as datetime objects that allow for proper filtering and sorting of the data. If you do not yet have the feature, you will be able edit your existing PivotTable.
- We fixed an issue when clicking on an email notification of at mention in a comment, the Excel app would close unexpectedly if the workbook was already open and was in a hidden window.
- We fixed an issue that compiled VBA macros more often.
- Fixed an issue that caused sync and co-auth failures in Office apps.
- We fixed an issue when you insert a People Graph add-in in RTL Excel, the application closes unexpectedly.
- We fixed an issue when you right click on a chart and select edit, the application closes unexpectedly.
- We fixed an issue when toggling the visibility of the ribbon with sheet tabs hidden the application would close unexpectedly.
- We fixed an issue where Clipboard locked alert is disrupting workflow for some users.
- We fixed an issue when you right click on a chart and select edit option the application closes unexpectedly.
- We fixed an issue in Word in which applying sketched outlines to pictures and saving, resulted in the file not being usable when copied and pasted into PowerPoint and Excel.
- We fixed an issue preventing the font dropdown’s scroll bar from correctly appearing in Office 2016 and Office 2019.
- We fixed an issue where a manually applied sensitivity label could be overridden by an automatic label if the automatic label has higher priority.
- We fixed an issue where «connecting to» dialog box was shown during Save/Save-As when a UNC path was set as default save directory.
- We fixed an issue with URL handling by Visual Basic macros.
- We fixed an issue where some content could stop working and not appear correctly after zooming with touchpad.
- We fixed an issue where Office will stop responding while using narrator when inside of a comment.
- We fixed an issue to default blocking macros from the Internet from executing.
- In Office 2016 and Office 365 with Visual Refresh, the visibility of hovered and pressed sliders in Colorful and White themes has been improved in task panes and dialogs.
- In Office 365 with Fluent visuals enabled, the visibility of hovered and pressed sliders in Dark Gray and Black themes has been improved in task panes and dialogs.
- In Office 365 with Visual Refresh Dark Gray theme, an issue preventing the border of the scroll buttons from appearing in the Ribbon Font Picker dropdown has been resolved.
- We fixed an issue in Color Picker text selection scenarios with Shapes and SmartArt.
- We fixed an instability issue related to animations for the user interface.
- We fixed an issue when editing a newly created file a business bar label did not upload correctly.
- We fixed an issue in Excel for images contained in filtered or hidden cells.
- We fixed an issue where cell references in charts were displaying incorrectly.
- We fixed an issue which caused Excel to close completely when choosing File > Close or pressing Ctrl+W to close the last workbook.
- We fixed an issue where Excel could use an unexpectedly high amount of CPU when freeze panes were enabled, but not every freeze pane was on the screen.
- We fixed an issue where the app closed unexpectedly when interacting with fonts.
- We fixed an issue where shared workbooks in .xls format may improperly merge changes.
- We fixed an issue where an AMSI scan would cause the app to close unexpectedly.
- We fixed a visual glitch in the Formula bar.
- We fixed an issue that caused Excel to close unexpectedly when showing live preview of a chart.
- We fixed an issue where shared workbooks in .xls format may improperly merge changes.
- We fixed an issue where an AMSI scan would cause the app to close unexpectedly.
- We fixed an issue that caused Excel to close unexpectedly when showing live preview of a chart.
- We fixed an issue where the letter «j» was not being properly inserted.
- We fixed an issue where running a VBA script / addin on a workbook with chart sheet may cause Excel to close unexpectedly.
- We fixed an issue with rendering in Excel and Project when using certain older builds of Windows 11.
- We fixed an unexpected stop responding in Office rendering code.
- We fixed an issue that caused Excel to consume excessive memory.
- We fixed an issue with rendering in Excel and Project when using certain older versions of Windows 11.
- We fixed an issue where using custom command bars could cause Excel to close unexpectedly.
- We fixed an issue where a recovered file would be opened as read-only.
- We fixed an issue displaying some SVG files.
- We fixed an issue which adjusts how gradients fill on a series in a waterfall chart aligns with gradient fills on series in a column chart.
- Various bugs and performance fixes.
- We fixed an issue where shapes and form controls could not call VBA macros.
- We fixed an issue where an application using the OLEDB API with the ACE.OLEDB.12.0 or ACE.OLEDB.16.0 provider was closing unexpectedly.
- We fixed an issue where opening XLSM file in SpreedsheetCompare tool can cause the tool to stop responding.
- We fixed an issue with the WEBSERVICE worksheet function, where Excel would stop working in rare cases when calculations are canceled by the user.
- We fixed issues that refreshing the data for PivotTables can stop working when filtered values no longer exist in the data, and a subsequent query statement generated without the invalid filtered values to retry the refresh request was temporarily disabled and is now reenabled.
- We fixed an issue where newly created PivotTables could lose custom settings if the data source range was changed.
- We fixed an issue where certain formula results aren’t updated after their inputs have changed.
- We fixed an issue where some worksheet functions were not appearing for users with certain languages.
- When opening linked tables to Dynamics, numbers may appear as small squares when the data is displayed. To work around this issue, open the link in Table Design view, and clear the Format property for any affected columns.
- We fixed an issue where a query update caused Excel to stop responding.
- We fixed an issue where on opening an Excel file, the cell selection was off.
- We fixed an issue where the app stop responding when we opened the privacy settings window and the default dialog manager is empty.
- Various bugs and performance fixes.
- Excel was clearing out the value for HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\Common\UserInfo\Company in non-MSI installs of Office. We have fixed this issue which primarily affected customers using non-MSI versions of Office.
- Addressed an issue where under rare circumstances Excel could stop responding while calculating a workbook.
- This version fixed a unexpected close which happened during save for some documents in tenants which opted into protected coauthoring if the local file cache had tenant Id datum formatted incorrectly.
- In certain customer configurations, it was discovered that document exports to PDF or XPS formats from Office would fail due to recent updates. This update fixed these regressions and reenabled export to these formats.
- Fixed an issue where not all columns may appear when linking to or importing from a Dynamics table.
- We fixed an issue where the «File» tab text was getting cut off in some languages.
- We fixed an issue where connecting to a data source from within the PowerPivot window was not working.
- We fixed a problem where the Analysis ToolPak add-in did not work with certain Automation Security settings.
- We fixed an issue bug that is causing office apps to stop responding, when multiple office apps are running at the same time. This also fixes other stability issues across the system that arises because of the reponse issue.
- We fixed an issue that caused date fields in PivotTables to be grouped incorrectly.
- We fixed an issue that may cause some linked Dynamics table to stop responding.
- In certain customer configurations, it has been discovered that document exports to PDF or XPS formats from Office may stop responding due to recent updates. This update fixes these regressions and reenables export to these formats.
- Fixed the issue where DRM-protected workbook cannot be opened from VBA if Application.DisplayAlerts is set to True.
- Fixed an issue where extra entries appeared in the Excel Add-in list for some users.
- Fixed an issue where user is unable to edit certain documents stored in OnPrem sharepoint servers.
- Fixed a unexpected close when reopening certain files.
- We fixed an issue where extra entries appeared in the Excel Add-in list for some users.
- Fixed an issue where the Analysis ToolPak add-in did not work for some users.
- Fixed an issue to enable the Name Manager to open on books with a large number of hidden names.
- Fix for an issue where a major version build rollback could result in crashes on file open.
- Fixed an issue where the Analysis ToolPak add-in did not work for some users.
- We fixed an issue that caused date formatting to be displayed incorrectly in some languages when using add-ins.
- We fixed an issue where some files would occasionally not able to open in Protected View
- Fixed an issue with automation add-ins for Excel that are not loading after installing April 2021 security update. Please use provided workaround for users not in Current Channel Learn more.
- Fixed a potential resource contention issue in word when drawing an image.
- Fixed bug where disabled commands in the Office Ribbon would only have the icon grayed out but not the text in Dark Gray Office Theme.
- We fixed an issue that prevented users from exporting an Excel workbook to PDF.
- We fixed an issue which caused images to bee smaller than expected when using the Paste Linked Picture option.
- Fixes an issue where Excel would fail to launch or close unexpectedly if certain Windows Security exploit protection settings (SimExec, CallerCheck) are in use
- We fixed an issue that broke some legacy Excel 4.0 and Excel5.0 macros as well as some VBA calls to dialogsheets.show.
- Fixes an issue where Excel would fail to launch or close unexpectedly if certain Windows Security exploit protection settings (SimExec, CallerCheck) are in use.
- Fixed an issue where Excel might close unexpectedly when using the «Show Values As» menu for a PivotTable.
- Fixed an issue where Excel may leave macros disabled without prompting when opening an Excel Add-in file containing Excel 4.0 Macros.
- Fixed an issue where some users would incorrectly see a message bar informing them of a new version of a file when coauthoring.
- This change addresses an issue with properly displaying fonts within equations.
Excel 2021/2019/2016 Update History
Because there doesn’t seem to be a simple page where you can see all the updates/fixes related to Excel, we’ve created a list with the links to the official articles from Microsoft here. (somehow they keep naming the latest perpetual version of Excel, Excel 2016 and not Excel 2019 or Excel 2021 in their documents)
Several of the fixes from Microsoft were related to the performance and/or crashes of Excel.
- Description of the security update for Excel 2016: March 14, 2023 (KB5002351)
This security update resolves a Microsoft Excel spoofing vulnerability and Microsoft Excel remote code execution vulnerability.
https://support.microsoft.com/en-us/topic/description-of-the-security-update-for-excel-2016-march-14-2023-kb5002351-8b3825d7-cb07-4478-b48c-9a2c02e5adde - Description of the security update for Excel 2016: November 8, 2022 (KB5002253)
This security update resolves a Microsoft Excel remote code execution vulnerability and Microsoft Excel security feature bypass vulnerability.
https://support.microsoft.com/en-us/topic/description-of-the-security-update-for-excel-2016-november-8-2022-kb5002253-6f07a592-5ec0-4208-8764-d3036fd82e21 - September 6, 2022, update for Office 2016 (KB5002251)
This update fixes an issue in which you receive an «Invalid password» error message when you try to open a Visual Basic for Applications (VBA) project by using the correct password. This issue occurs after security update 5002112 is installed.
https://support.microsoft.com/en-us/topic/september-6-2022-update-for-office-2016-kb5002251-4e5fb8ec-31db-4f13-8b55-b226c8e8e5d7 - Description of the security update for Excel 2016: August 9, 2022 (KB5002232)
Fixes an issue in which shared workbooks in .xls format might incorrectly merge changes.
https://support.microsoft.com/en-us/topic/description-of-the-security-update-for-excel-2016-august-9-2022-kb5002232-175720b0-ac6a-47cc-a983-c770d4bb8c44 - June 7, 2022, update for Office 2016 (KB4484104)
This update fixes an issue in which opening files from Windows Start Menu or Office Online may fall back to opening in read-only mode.
https://support.microsoft.com/en-us/topic/june-7-2022-update-for-office-2016-kb4484104-ddd7da49-55ff-eb6b-f819-ce572fbfda4a - April 6, 2021, update for Office 2016 (KB4486672)
Some users might experience an issue in which an Office application stops responding because of Office registry code. To fix this issue, install this update, and then set the following registry value.
https://support.microsoft.com/en-us/topic/april-6-2021-update-for-office-2016-kb4486672-2314aba4-d093-f6b8-5e21-5b6d9ee18b65 - Description of the security update for Excel 2016: January 12, 2021
— Fixes an Excel crash when there is a Group Policy Object update (for example, through Remote Group Policy Refresh) during multithreaded recalculation.
— Fixes an issue in which Excel crashes when users insert subtotals on more than 255 columns that have the same column name through the Subtotal dialog box under Data > Outline > Subtotal.
https://support.microsoft.com/en-us/topic/description-of-the-security-update-for-excel-2016-january-12-2021-a2d6771e-f3be-1154-8e73-f1f56b9439a5 - January 5, 2021, update for Office 2016 (KB4493157)
This update provides an improvement for Visual Basic for Applications (VBA) projects signature scheme.
https://support.microsoft.com/en-us/topic/january-5-2021-update-for-office-2016-kb4493157-8bcb4fe4-ff77-42f1-dafb-69a4104021ee - Description of the security update for Excel 2016: December 8, 2020
— Adds security enhancements that provide a more secure version of the signature scheme for Visual Basic for Applications (VBA) projects.
https://support.microsoft.com/en-ca/help/4486754/security-update-for-excel-2016-december-8-2020 - Description of the security update for Excel 2016: November 10, 2020
This security update contains fixes for the following nonsecurity issues:
— Fixes an issue in which cell references may be wrong when you programmatically set a formula through Range.FormulaR1C1 while a chart sheet is active.
— Fixes an issue in which files might not load because printer driver information is reported as invalid.
https://support.microsoft.com/en-us/help/4486718/security-update-for-excel-2016-november-10-2020 - Description of the security update for Excel 2016: October 13, 2020
Fixes an issue in which Excel sometimes stops responding when it calculates printer information.
https://support.microsoft.com/en-us/help/4486678/security-update-for-excel-2016-october-13-2020 - Description of the security update for Excel 2016: September 8, 2020
https://support.microsoft.com/en-us/help/4484507/security-update-for-excel-2016-september-8-2020 - Description of the security update for Excel 2016: August 11, 2020
https://support.microsoft.com/en-us/help/4484465/security-update-for-excel-2016-august-11-2020 - July 7, 2020, update for Excel 2016 (KB4484437)
This update fixes an issue in which Excel will become unresponsive after you use Ctrl+Shift+Arrow keys to scroll when the Excel window is shared through Teams.
https://support.microsoft.com/en-us/help/4484437/july-7-2020-update-for-excel-2016-kb4484437 - Description of the security update for Office 2016: June 9, 2020
https://support.microsoft.com/en-us/help/4484342/security-update-for-office-2016-june-9-2020 - Description of the security update for Excel 2016: June 9, 2020
This security update contains fixes for the following nonsecurity issues:
— Excel crashes when you switch between two workbooks that have different zoom level. For example, this issue occurs if the workbooks are in page layout.
https://support.microsoft.com/en-us/help/4484403/security-update-for-excel-2016-june-9-2020 - June 2, 2020, update for Office 2016 (KB4484335)
https://support.microsoft.com/en-us/help/4484335/june-2-2020-update-for-office-2016-kb4484335 - Description of the security update for Excel 2016: May 12, 2020
This update contains fixes for the following nonsecurity issues:
— The execution of ribbon callbacks to Visual Basic for Applications (VBA) macros can cause the ScreenUpdating property to unexpectedly be reset to True.
— A crash occurs when you use the IBM Cognos Analysis for Microsoft Excel add-in.
— A crash occurs intermittently when you use the Find and Replace feature in the Korean language version of Excel.
https://support.microsoft.com/en-us/help/4484338/security-update-for-excel-2016-may-12-2020 - Description of the security update for Office 2016: April 14, 2020
https://support.microsoft.com/en-us/help/4484214/security-update-for-office-2016-april-14-2020 - Description of the security update for Office 2016: April 14, 2020
The security update addresses the vulnerability by correcting how Microsoft Excel handles objects in memory.
https://support.microsoft.com/en-us/help/4484258/security-update-for-office-2016-april-14-2020 - Description of the security update for Office 2016: April 14, 2020
This security update contains a fix for the following nonsecurity issue:
— An application crashes when using Open Database Connectivity (ODBC) APIs to use multiple connections with a Microsoft Access or Excel Driver.
https://support.microsoft.com/en-us/help/4484287/security-update-for-office-2016-april-14-2020 - Description of the security update for Excel 2016: April 14, 2020
https://support.microsoft.com/en-us/help/4484273/security-update-for-excel-2016-april-14-2020 - April 7, 2020, update for Office 2016 (KB4484106)
https://support.microsoft.com/en-us/help/4484106/april-7-2020-update-for-office-2016-kb4484106 - March 10, 2020, update for Excel 2016 (KB4011130)
This update fixes the following issue:
— Data in cells isn’t read by the Windows Narrator screen reader.
https://support.microsoft.com/en-us/help/4011130/march-10-2020-update-for-excel-2016-kb4011130 - March 3, 2020, update for Office 2016 (KB4484247)
This update fixes an issue in which you may receive an error message when you use an ADODB.Recordset object. The error may occur after you use a Recordset object, close it, and then use another Recordset object.
https://support.microsoft.com/en-us/help/4484247/march-3-2020-update-for-office-2016-kb4484247 - Description of the security update for Excel 2016: February 11, 2020
https://support.microsoft.com/en-us/help/4484256/security-update-for-excel-2016-february-11-2020 - Description of the security update for Excel 2016: January 14, 2020
This security update contains fixes for the following nonsecurity issues:
— Fixed: Excel crash issues.
— .
https://support.microsoft.com/en-us/help/4484217/security-update-for-excel-2016-january-14-2020 - Description of the security update for Excel 2016: December 10, 2019
You may receive the following error message when you open a file that is protected by Information Rights Management:
«This application is not trusted to consume rights managed content. The Authenticode signature for the application is not valid. Contact your administrator for further investigation.»
To resolve this issue, install Office update 3178666.
https://support.microsoft.com/en-us/help/4484179/security-update-for-excel-2016-december-10-2019 - November 5, 2019, update for Office 2016 (KB4484138)
This update fixes the following issue:
— Excel may crash when you live preview a pivot chart. This issue occurs when the pivot chart is a combo chart with data labels.
https://support.microsoft.com/en-us/help/4484138/november-5-2019-update-for-office-2016-kb4484138 - Description of the security update for Excel 2016: November 12, 2019
This security update contains improvements and fixes for the following nonsecurity issues:
— Improves the performance of the Filter by color feature.
— When you use a marquee to indicate that some cells are selected, the marquee isn’t always displayed as expected. This makes it difficult for you to know which cells have been selected when you select cells on multiple worksheets.
— You have browsed many add-ins in the Excel Add-ins dialog box. However, when you open the dialog box again, only the first 16 browsed add-ins are listed.
— A pivot table doesn’t display expected results for certain attribute members in rows or columns when it’s refreshed. However, a pivot table can display the attributes if they are moved to a filter.
— Excel 2016 crashes intermittently when you work on workbooks.
https://support.microsoft.com/en-us/help/4484144/security-update-for-excel-2016-november-12-2019 - Description of the security update for Office 2016: September 10, 2019
This security update contains improvements and fixes for the following nonsecurity issues:
— Improves the performance of ribbon Key Tips in Windows 10. To enable this improvement, add the DWORD registry value UseAsyncRibbonKeytips and set its value data to 1 in the HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common location.
— You are prompted for credentials when Office 2016 opens a web resource from the content on a SharePoint site. For example, you are prompted when you copy and paste a site name from a page to an external Excel workbook.
https://support.microsoft.com/en-us/help/4475583/security-update-for-office-2016-september-10-2019 - Description of the security update for Office 2016: September 10, 2019
This security update contains a fix for the following nonsecurity issue:
It may take longer than in earlier versions of Office to refresh PivotTables that are connected to external data, such as Access databases or other Excel workbooks on a network share.
https://support.microsoft.com/en-us/help/4475591/security-update-for-office-2016-september-10-2019 - Description of the security update for Excel 2016: September 10, 2019
— When two or more workbooks are open, and at least one workbook contains a macro, the Excel Ribbon may be disabled when you select rows or columns.
— You may sometimes experience a «0x800A03EC» error when you use a VBA macro to update Power Query data.
https://support.microsoft.com/en-us/help/4475579/security-update-for-excel-2016-september-10-2019 - September 3, 2019, update for Office 2016 (KB4464584)
https://support.microsoft.com/en-us/help/4464584/september-3-2019-update-for-office-2016-kb4464584 - September 3, 2019, update for Office 2016 (KB4464531)
https://support.microsoft.com/en-us/help/4464531/september-3-2019-update-for-office-2016-kb4464531 - September 3, 2019, update for Office 2016 (KB4011629)
https://support.microsoft.com/en-us/help/4464531/september-3-2019-update-for-office-2016-kb4464531 - August 6, 2019, update for Office 2016 (KB4475516)
https://support.microsoft.com/en-us/help/4475516/august-6-2019-update-for-office-2016-kb4475516 - August 6, 2019, update for Excel 2016 (KB4475550)
— After you upgrade Windows 7 to Windows 10, some Excel files with defined names can’t be opened if you change the regional format to Chinese.
— Improves performance of protect and unprotect worksheets for macros.
https://support.microsoft.com/en-us/help/4475550/august-6-2019-update-for-excel-2016-kb4475550 - July 2, 2019, update for Office 2016 (KB4464582)
A hang occurs when you open an Office document that references a nonexistent template.
https://support.microsoft.com/en-us/help/4464582/july-2-2019-update-for-office-2016-kb4464582 - Description of the security update for Excel 2016: July 9, 2019
When you switch rows and columns in a Pivot Chart, and then you undo the switch operation, Microsoft Excel 2016 crashes.
https://support.microsoft.com/en-us/help/4475513/security-update-for-excel-2016-july-9-2019 - June 4, 2019, update for Excel 2016 (KB4464578)
https://support.microsoft.com/en-us/help/4464578/june-4-2019-update-for-excel-2016-kb4464578 - May 7, 2019, update for Excel 2016 (KB4464550)
If you install the update 4462115 or later Excel updates, after you select the total row or column, Excel 2016 crashes.
https://support.microsoft.com/en-us/help/4464550/may-7-2019-update-for-excel-2016-kb4464550 - Description of the security update for Office 2016: April 9, 2019
Fixes the issue in which some users are unnecessarily forced into a state in which the hardware acceleration is turned off.
https://support.microsoft.com/en-us/help/4462242/description-of-the-security-update-for-office-2016-april-9-2019 - Description of the security update for Excel 2016: April 9, 2019
Contains fixes for the following nonsecurity issues:
— If a file has multiple cells that use Japanese era dates, Excel 2016 may crash when the file opens.
— When a protected workbook and an editable workbook are opened at the same time, copying cells in the editable workbook causes high CPU usage.
https://support.microsoft.com/en-us/help/4462236/description-of-the-security-update-for-excel-2016-april-9-2019 - March 5, 2019, update for Office 2016 (KB4461439)
This update fixes the following issue:
When you click on a shape within a chart in a protected worksheet and preview a chart style or chart color scheme, Excel 2016 crashes.
https://support.microsoft.com/en-us/help/4461439/march-5-2019-update-for-office-2016-kb4461439 - March 5, 2019, update for Excel 2016 (KB4462212)
https://support.microsoft.com/en-us/help/4462212/march-5-2019-update-for-excel-2016-kb4462212 - February 12, 2019, Description of the security update for Excel 2016
https://support.microsoft.com/en-us/help/4462115/description-of-the-security-update-for-excel-2016-february-12-2019 - January 2, 2019, update for Excel 2016 (KB4461600)
https://support.microsoft.com/en-us/help/4461600/january-2-2019-update-for-excel-2016-kb4461600 - December 11, 2018, Update for Excel 2016
https://support.microsoft.com/en-us/help/4461542/descriptionofthesecurityupdateforexcel2016december112018 - November 13, 2018, Update for Excel 2016
This security update contains improvements and fixes for the following nonsecurity issues:
— When you right-click the Excel icon in the taskbar and select Close all windows, Excel 2016 crashes sometimes.
— When you save a workbook that contains external references to cells that contain metadata from another workbook, for example, a rich data type value, Excel 2016 crashes.
— When you programmatically copy a very hidden sheet to a new workbook by using the Worksheet.Copy method, Excel 2016 crashes.
— Assume that a workbook contains merged cells. When you hide, filter, or outline rows in the workbook, Excel 2016 may freeze.
https://support.microsoft.com/en-us/help/4461503/description-of-the-security-update-for-excel-2016-november-13-2018 - October 16, 2018. Update for Office
Fixed various performance issues.
https://docs.microsoft.com/en-us/officeupdates/monthly-channel-2018#version-1809-october-16 - October 9, 2018, Update for Excel 2016
This security update contains improvements and fixes for the following nonsecurity issues:
— When you show details of a collapsed group by clicking the Show Details command, Excel 2016 may freeze.
https://support.microsoft.com/en-us/help/4461448/description-of-the-security-update-for-excel-2016-october-9-2018 - September 11, 2018, Update for Excel 2016
This security update contains improvements and fixes for the following nonsecurity issues:
— When you convert a large range of cells from Text to Number, Excel 2016 may appear to be frozen.
— It may take a long time to delete columns that contain merged cells.
https://support.microsoft.com/en-us/help/4092460/description-of-the-security-update-for-excel-2016-september-11-2018 - September 4, 2018, update for Office 2016 (KB4022215)
https://support.microsoft.com/en-us/help/4022215/september-4-2018-update-for-office-2016-kb4022215 - September 4, 2018, update for Office 2016 (KB3114853)
https://support.microsoft.com/en-us/help/3114853/september-4-2018-update-for-office-2016-kb3114853 - September 4, 2018, update for Office 2016 (KB4092449)
https://support.microsoft.com/en-us/help/4092449/september-4-2018-update-for-office-2016-kb4092449 - August 14, 2018, update for Excel 2016
This security update contains improvements and fixes for the following nonsecurity issues:
— Excel hangs intermittently in some cases. For example, Excel hangs when you paste many pictures into a worksheet and type text into cells. It also hangs when you paste a picture into a worksheet and then resize or move the picture.
— Excel hangs in specific cases. For example, tapping near the New Sheet button in a workbook on a touch-enabled computer can cause Excel to hang.
— Assume that you open several Excel workbooks in Protected view. When you unprotect and edit one of them, high CPU usage occurs.
https://support.microsoft.com/en-us/help/4032229/description-of-the-security-update-for-excel-2016-august-14-2018 - August 7, 2018, update for Office 2016 (KB4032234)
https://support.microsoft.com/en-us/help/4032234/august-7-2018-update-for-office-2016-kb4032234 - July 3, 2018, update for Excel 2016 (KB4022229)
https://support.microsoft.com/en-us/help/4022229/july-3-2018-update-for-excel-2016-kb4022229 - July 3, 2018, update for Office 2016 (KB4018385)
https://support.microsoft.com/en-us/help/4018385/july-3-2018-update-for-office-2016-kb4018385 - Description of the security update for Excel 2016: June 12, 2018
https://support.microsoft.com/en-us/help/4022174/description-of-the-security-update-for-excel-2016-june-12-2018 - June 5, 2018, update for Office 2016 (KB4022159)
https://support.microsoft.com/en-us/help/4022159/june-5-2018-update-for-office-2016-kb4022159 - Description of the security update for Excel 2016: May 8, 2018
When you try to print Excel 2016 documents and scroll by using the mouse wheel after the printer driver dialog box appears, Excel crashes.
https://support.microsoft.com/en-us/help/4018382/description-of-the-security-update-for-excel-2016-may-8-2018 - Description of the security update for Excel 2016: April 10, 2018
When you open a worksheet that contains an external reference that includes metadata, for example a rich data type value in Microsoft Excel 2016, Excel crashes.
https://support.microsoft.com/en-us/help/4018337/description-of-the-security-update-for-excel-2016-april-10-2018 - March 13, 2018, update for Office 2016 (KB4011727)
https://support.microsoft.com/en-us/help/4011727/description-of-the-security-update-for-excel-2016-march-13-2018 - February 6, 2018, update for Excel 2016 (KB4011684)
https://support.microsoft.com/en-za/help/4011684/february-6-2018-update-for-excel-2016-kb4011684 - January 9, 2018, Update for Excel 2016 (KB4011627)
You may experience intermittent crashes in Excel during background error checking after you copy sheets between workbooks.
https://support.microsoft.com/en-us/help/4011627/descriptionofthesecurityupdateforexcel2016january9-2018 - January 2, 2018 — Version 1711 (Build 8730.2165)
Fix an issue where the programmatic creation of a PivotTable followed by a programmatic refresh causes Excel to crash.
Fix an issue where programmatically calling Workbook.Open() may cause Excel to crash.https://technet.microsoft.com/en-us/office/mt465751
- December 5, 2017, update for Excel 2016 (KB4011577)
https://support.microsoft.com/en-us/help/4011577/december-5-2017-update-for-excel-2016-kb4011577
https://support.microsoft.com/en-us/help/4011218/december-5-2017-update-for-office-2016-kb4011218
https://support.microsoft.com/en-us/help/4011211/december-5-2017-update-for-office-2016-kb4011211 - November 27, 2017, Excel version 1710 (Build 8625.2139)
Fix an issue where the user incorrectly sees a «catastrophic failure» error message when opening an Office 2007 or older workbook (.xls or .xla) with macros.
https://technet.microsoft.com/en-us/office/mt465751 - Description of the security update for Excel 2016: November 14, 2017
https://support.microsoft.com/en-us/help/4011220/description-of-the-security-update-for-excel-2016-november-14-2017 - October 3, 2017, update for Excel 2016 (KB4011166)
https://support.microsoft.com/en-us/help/4011166/october-3-2017-update-for-excel-2016-kb4011166 - October 3, 2017, update for Office 2016 (KB4011135)
https://support.microsoft.com/en-us/help/4011135/october-3-2017-update-for-office-2016-kb4011135 - September 12, 2017, update for Excel 2016 (KB4011165)
https://support.microsoft.com/en-gb/help/4011165/september-12-2017-update-for-excel-2016-kb4011165 - Description of the security update for Excel 2016: September 12, 2017
https://support.microsoft.com/en-us/help/4011050/descriptionofthesecurityupdateforexcel2016september12-2017 - August 8, 2017, update for Excel 2016 (KB3085435)
https://support.microsoft.com/en-us/help/3085435/august-8-2017-update-for-excel-2016-kb3085435 - Description of the security update for Excel 2016: July 11, 2017
https://support.microsoft.com/en-us/help/3203477/descriptionofthesecurityupdateforexcel2016july11-2017 - June 6, 2017, update for Excel 2016 (KB3191922)
https://support.microsoft.com/en-us/help/3191922/june-6-2017-update-for-excel-2016-kb3191922 - May 2, 2017, update for Excel 2016 (KB3191861)
https://support.microsoft.com/en-us/help/3191861/may-2-2017-update-for-excel-2016-kb3191861 - April 4, 2017, update for Excel 2016 (KB3178719)
https://support.microsoft.com/en-us/help/3178719/april-4-2017-update-for-excel-2016-kb3178719 - MS17-014: Description of the security update for Excel 2016: March 14, 2017
https://support.microsoft.com/en-us/help/3178673/ms17-014-description-of-the-security-update-for-excel-2016-march-14-20 - February 7, 2017, update for Office 2016 (KB3141508)
You may experience unexpected issues in Excel 2016 that has multiple third-party add-ins loaded. For example, you may be unable to save a workbook to a mapped network drive.
https://support.microsoft.com/en-us/help/3141508/february-7-2017-update-for-office-2016-kb3141508 - January 3, 2017, update for Excel 2016 (KB3141472)
https://support.microsoft.com/en-us/help/3141472/january-3—2017—update-for-excel-2016-kb3141472 - MS16-148: Description of the security update for Excel 2016: December 13, 2016
https://support.microsoft.com/en-us/help/3128016/ms16-148-description-of-the-security-update-for-excel-2016-december-13 - MS16-133: Description of the security update for Excel 2016: November 8, 2016
https://support.microsoft.com/en-us/help/3127904/ms16-133-description-of-the-security-update-for-excel-2016-november-8 - October 4, 2016, update for Excel 2016 (KB3118373)
https://support.microsoft.com/en-us/help/3118373/october-4—2016—update-for-excel-2016-kb3118373 - MS16-107: Description of the security update for Excel 2016: September 13, 2016
https://support.microsoft.com/en-us/help/3118290/ms16-107-description-of-the-security-update-for-excel-2016-september-1 - September 6, 2016, update for Office 2016 (KB3115495)
https://support.microsoft.com/en-us/help/3115495/september-6—2016—update-for-office-2016-kb3115495 - August 9, 2016, update for Excel 2016 (KB3115438)
https://support.microsoft.com/en-us/help/3115438/august-9—2016—update-for-excel-2016-kb3115438 - August 2, 2016, update for Office 2016 (KB3115270)
https://support.microsoft.com/en-us/help/3115270/august-2—2016—update-for-office-2016-kb3115270 - Excel workbooks may not open after MS16-088 is installed
https://support.microsoft.com/en-us/help/3181507/excel-workbooks-may-not-open-after-ms16-088-is-installed - MS16-088: Description of the security update for Excel 2016: July 12, 2016
https://support.microsoft.com/en-us/help/3115272/ms16-088-description-of-the-security-update-for-excel-2016-july-12—20 - July 5, 2016, update for Office 2016 (KB3115266)
https://support.microsoft.com/en-us/help/3115266/july-5—2016—update-for-office-2016-kb3115266 - June 7, 2016, update for Excel 2016 (KB3115139)
https://support.microsoft.com/en-us/help/3115139/june-7—2016—update-for-excel-2016-kb3115139 - May 3, 2016, update for Excel 2016 (KB3115090)
https://support.microsoft.com/en-us/help/3115090/may-3—2016—update-for-excel-2016-kb3115090 - MS16-042: Description of the security update for Excel 2016: April 12, 2016
https://support.microsoft.com/en-us/help/3114964/ms16-042-description-of-the-security-update-for-excel-2016-april-12—2 - April 5, 2016, update for Office 2016 (KB3114958)
https://support.microsoft.com/en-us/help/3114958/april-5—2016—update-for-office-2016-kb3114958 - March 8, 2016, update for Excel 2016 (KB3114848)
https://support.microsoft.com/en-us/help/3114848/march-8—2016—update-for-excel-2016-kb3114848 - MS16-015: Description of the security update for Excel 2016: February 9, 2016
https://support.microsoft.com/en-us/help/3114698/ms16-015-description-of-the-security-update-for-excel-2016-february-9 - February 9, 2016, update for Office 2016 (KB3114706)
https://support.microsoft.com/en-us/help/3114706/february-9—2016—update-for-office-2016-kb3114706 - MS16-004: Description of the security update for Excel 2016: January 12, 2016
https://support.microsoft.com/en-us/help/3114520/ms16-004-description-of-the-security-update-for-excel-2016-january-12 - January 12, 2016, update for Office 2016 (KB3114531)
https://support.microsoft.com/en-us/help/3114531/january-12—2016—update-for-office-2016-kb3114531 - December 8, 2015, update for Excel 2016 (KB3114374)
https://support.microsoft.com/en-us/help/3114374/december-8-2015-update-for-excel-2016-kb3114374
Microsoft Office Update History
General MS Office update information for Office 365, 2021, 2019, 2016, Office 2013, Office 2010 and Office 2007: