So I went ahead and found the release notes of Microsoft AutoUpdate and found that it can be downloaded and installed separately from Office itself. In contrary to others on the forum, it did not fix the issue for me. Hostname:~ user$ sudo launchctl load -w /Library/LaunchAgents/.plist Hostname:~ user$ sudo launchctl unload -w /Library/LaunchAgents/.plist Hostname:~ user$ sudo launchctl stop /Library/LaunchAgents/.plist Hostname:~ user$ sudo chown root:wheel /Library/LaunchAgents/.plist hostname:~ user$ sudo chown root:wheel /Library/LaunchDaemons/.plist The permissions of the AutoUpdate files should be root:wheel according to the post. While searching for a solution on the Microsoft Office forum, I found a post that mentioned to check the AutoUpdate file permissions in the LauchAgents and LaunchDeamons system folder and reload it. The MAU version that had the issues was v4.39 (September 14, 2021). This was really annoying, because Office apps kept notifying me of available updates after every restart of one of the Office apps. Now it did open the tool, but it looked like it failed updating itself and got stuck in the “Installing” state before it could update Office. Normally it starts Microsoft AutoUpdate (MAU) which searches for Office updates. You can always ask an expert in the Excel Tech Community or get support in the Answers community.A constant appearing message in Word and Excel about to “Check for updates” triggered me to start updating Microsoft Office on my Mac. If you want to delete your drop-down list, see Remove a drop-down list. For example, check to see if the cell is wide enough to show your updated entries. If the Source box contains a named range, like Departments, then you need to change the range itself using a desktop version of Excel.Īfter you update a drop-down list, make sure it works the way you want. Then click and drag to select the new range containing the entries. If the list of entries ends up being longer or shorter than the original range, go back to the Settings tab and delete what's in the Source box.

In this example, you'd add or remove entries in cells A2 through A5. If the Source box contains a reference to a range of cells (for example, =$A$2:$A$5), click Cancel, and then add or remove entries from those cells. For example: Fruits,Vegetables,Meat,Deli. When you're done, each entry should be separated by a comma, with no spaces. If the Source box contains drop-down entries separated by commas, then type new entries or remove ones you don't need. On the Settings tab, click in the Source box. Select the cells that have the drop-down list. In Excel for the web, you can only edit a drop-down list where the source data has been entered manually.

Update office mac