Excel Mac Update
This Excel tutorial explains how to change the data source for a pivot table in Excel 2011 for Mac (with screenshots and step-by-step instructions).
Excel for Microsoft 365 for Mac Word for Microsoft 365 for Mac Outlook for Microsoft 365 for Mac PowerPoint for Microsoft 365 for Mac Office 2019 for Mac Excel 2019 for Mac. And have automatic updates turned on, your apps will update automatically. But you can also manually download the updates: Open the Mac App Store from your Dock. Security updates Excel. CVE-2020-17067; October 13, 2020. Version 16.42 (Build 20101102) Feature updates Excel. Refresh data from Microsoft SQL Server: Refresh your Power Query queries on Mac from Microsoft SQL Server. Create Variables to Use in Formulas: Improve performance, readability, and composability with the LET function. You now can add data to Excel directly from a photo. Using the Excel app, just take a picture of a printed data table on your Android or iPhone device and automatically convert the picture into a fully editable table in Excel. This new image recognition functionality. If the Update option is missing or you're unable to update, try Microsoft Update to install your Office updates through Windows. To download an update manually, see Office Updates. If you would like to update Office but can't open any of your Office apps, try repairing your Office suite: Go to Control Panel Programs Uninstall a program. Download Microsoft Word for macOS 10.13 or later and enjoy it on your Mac. This application requires a qualifying Microsoft 365 subscription. Microsoft 365 includes premium Word, Excel, and PowerPoint apps, 1 TB cloud storage in OneDrive, advanced security, and more, all in one convenient subscription.
See solution in other versions of Excel:
Question: In Microsoft Excel 2011 for Mac, I've created a pivot table and now I need to change the data source. How do I change the data source for an existing pivot table?
Answer:Click somewhere in the pivot table and the PivotTable tab should appear in the toolbar at the top of the screen. Select the PivotTable tab, click on the Options button and select Change Source from the popup menu.
When the Change PivotTable Data Source window appears, change the Location value to reflect the new data source for your pivot table. Click on the OK button.
Now when you return to your pivot table, it should display information from the new data source.
-->Office for Mac that comes with a Microsoft 365 subscription is updated on a regular basis to provide new features, security updates, and non-security updates. The following information is primarily intended for IT professionals who are deploying Office for Mac to the users in their organizations.
Note
- Starting with Version 16.21, Microsoft Teams will be installed by default for new installations if you're using the Office suite install package. For more information, see Microsoft Teams installations on a Mac.
- For security reason, Microsoft has deprecated the use of SHA-1. Learn more
- Starting with the 16.17 release in September 2018, this information also applies to Office 2019 for Mac, which is a version of Office for Mac that’s available as a one-time purchase from a retail store or through a volume licensing agreement.
- For information about the features, security updates, and non-security updates that are included in a given release of Office for Mac, see Release notes for Office for Mac.
- For early access to new releases, join the Office Insider program.
Most current packages for Office for Mac
The following table lists the most current packages for the Office suite and for the individual applications. The Office suite includes all the individual applications, such as Word, PowerPoint, and Excel. All packages are 64-bit only. The build date is listed in parentheses, in a YYMMDD format, after the version number. The install package is used if you don't have the application already installed, while the update package is used to update an existing installation.
To view release notes, see Release notes.
November 10, 2020
Version 16.43 (20110804)
Application | Download links | SHA-256 hash for install package |
---|---|---|
Office suite (with Teams) | Install package | 3D4A3CBAB382850455D52DE764675293F25F66DBCBA31E5981930A5739B0D39D |
Office suite (without Teams) | Install package | 7609CD86617723F80DEA8DBD244A2D9A4F035F8019864833DE6A9E64E62F73A9 |
Word | Install package Update package | 3D957D534FB2142F6E95A688552890A31F0D942796F0128CA837A3E98405D413 |
Excel | Install package Update package | 2711A1B8864F7474458086B4B0A56673FEE0097D2049F276788C50E004C47D72 |
PowerPoint | Install package Update package | A89E0AED18E5B1E56293B1F9EACCC3E3F5089EB37A9EEC64BB6F3A3FA90587EB |
Outlook | Install package Update package | 0E53ACEFAFC25D1EEBBF257F343DE0D0A5258099C154F7BA5D99AA709FB50D08 |
OneNote | Update package | Not applicable |
Release history for Office for Mac
The following table provides release history information and download links for Office for Mac. The table is ordered by release date, with the most recent release date listed first. The build date is listed in parentheses, in a YYMMDD format, after the version number. All releases after August 22, 2016 are 64-bit only. All releases prior to August 22, 2016 are 32-bit only.
Update Excel In Mac
Note
- Download links are only provided for the most recent releases.
- Only the most recently released version listed below is supported.
Microsoft Excel Update Mac
Release date | Version | Install package | Update packages |
---|---|---|---|
November 10, 2020 | 16.43 (20110804) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
October 13, 2020 | 16.42 (20101102) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
September 15, 2020 | 16.41 (20091302) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
August 11, 2020 | 16.40 (20081000) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
July 14, 2020 | 16.39 (20071300) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
June 16, 2020 | 16.38 (20061401) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
May 12, 2020 | 16.37 (20051002) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
April 21, 2020 | 16.36 (20041300) | Office suite (with Teams) Office suite (without Teams) | |
April 14, 2020 | 16.36 (20041300) | Word, Excel, PowerPoint, Outlook, OneNote | |
March 10, 2020 | 16.35 (20030802) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
February 11, 2020 | 16.34 (20020900) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
January 14, 2020 | 16.33 (20011301) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
December 10, 2019 | 16.32 (19120802) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
November 12, 2019 | 16.31 (19111002) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
October 15, 2019 | 16.30 (19101301) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
September 18, 2019 | 16.29.1 (19091700) | Word, Excel, PowerPoint | |
September 10, 2019 | 16.29 (19090802) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
August 13, 2019 | 16.28 (19081202) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
July 16, 2019 | 16.27 (19071500) | Office suite (with Teams) Office suite (without Teams) | Word, Excel, PowerPoint, Outlook, OneNote |
June 11, 2019 | 16.26 (19060901) | ||
May 14, 2019 | 16.25 (19051201) | ||
April 16, 2019 | 16.24 (19041401) | ||
March 27, 2019 | 16.23.1 (19032603) | ||
March 12, 2019 | 16.23.0 (19030902) | ||
February 20, 2019 | 16.22 (19022000) | ||
January 24, 2019 | 16.21 (19011700) | ||
January 16, 2019 | 16.21 (19011500) | ||
December 11, 2018 | 16.20 (18120801) | ||
November 13, 2018 | 16.19 (18110915) | ||
October 16, 2018 | 16.18 (18101400) | ||
September 11, 2018 | 16.17 (18090901) | ||
August 14, 2018 | 16.16 (18081201) | ||
July 10, 2018 | 16.15 (18070902) | ||
June 13, 2018 | 16.14.1 (18061302) | ||
June 12, 2018 | 16.14.0 (18061000) | ||
May 24, 2018 | 16.13.1 (18052304) | ||
May 23, 2018 | 16.13.1 (18052203) | ||
May 15, 2018 | 16.13.0 (18051301) | ||
April 11, 2018 | 16.12.0 (18041000) | ||
March 19, 2018 | 16.11.1 (18031900) | ||
March 13, 2018 | 16.11.0 (18031100) | ||
February 13, 2018 | 16.10.0 (18021001) | ||
January 26, 2018 | 16.9.1 (18012504) | ||
January 18, 2018 | 16.9.0 (18011602) | ||
December 12, 2017 | 15.41.0 (17120500) | ||
November 14, 2017 | 15.40.0 (17110800) | ||
October 10, 2017 | 15.39.0 (17101000) | ||
September 12, 2017 | 15.38.0 (17090200) | ||
August 15, 2017 | 15.37.0 (17081500) | ||
July 21, 2017 | 15.36.1 (17072101) | ||
July 11, 2017 | 15.36.0 (17070200) | ||
June 16, 2017 | 15.35.0 (17061600) | ||
June 13, 2017 | 15.35.0 (17061000) | ||
May 16, 2017 | 15.34.0 (17051500) | ||
April 11, 2017 | 15.33.0 (17040900) | ||
March 14, 2017 | 15.32.0 (17030901) | ||
February 16, 2017 | 15.31.0 (17021600) | ||
January 11, 2017 | 15.30.0 (17010700) |