# microsoft office

* [office](#office)
* [outlook](#outlook)
  * [profiles](#profiles)
* [word](#word)
  * [logs](#logs)
  * [disable animations](#disable-animations)
* [powerpoint](#powerpoint)
  * [create and add new template](#create-and-add-new-template)
  * [import new template](#import-new-template)
* [excel](#excel)
  * [shortcuts](#shortcuts)

{% hint style="info" %}
> reference:
>
> * [pbowden-msft/Unlicense](https://github.com/pbowden-msft/Unlicense/blob/master/Unlicense)
> * [Rebuild the Office database](https://support.microsoft.com/en-us/office/rebuild-the-office-database-c21643be-0f0d-4997-9ec1-8044080054b0)
> * [Outlook 2016 for Mac repeatedly prompts for authentication](https://docs.microsoft.com/en-us/outlook/troubleshoot/sign-in/repeated-prompts-authentication)
> * [Office for Mac repeatedly requesting keychain access](https://support.microsoft.com/en-us/office/office-for-mac-repeatedly-requesting-keychain-access-ced5a09c-3099-47cb-9190-e961bf63e240)
> * [If your Mac keeps asking for the login keychain password](https://support.apple.com/en-gb/HT201609)
> * [How to remove Office license files on a Mac](https://support.microsoft.com/en-us/office/how-to-remove-office-license-files-on-a-mac-b032c0f6-a431-4dad-83a9-6b727c03b193)
> * [Troubleshoot install or activation errors for Office for Mac](https://support.microsoft.com/en-us/office/what-to-try-if-you-can-t-install-or-activate-office-for-mac-5efba2b4-b1e6-4e5f-bf3c-6ab945d03dea?wt.mc_id=scl_installoffice_mac)
> * [Configure keychain](https://docs.microsoft.com/en-us/azure/active-directory/develop/howto-v2-keychain-objc?tabs=objc)

> download
>
> * [Microsoft Office 16.45.21011103](https://apphub.online/p/microsoft-office)
>   * [Microsoft\_Office\_16.45.21011103\_BusinessPro\_Installer.pkg](https://officecdn-microsoft-com.akamaized.net/pr/C1297A47-86C4-4C1F-97FA-950631F94777/MacAutoupdate/Microsoft_Office_16.45.21011103_BusinessPro_Installer.pkg)
>   * [Microsoft\_Word\_16.45.21011103\_Installer.pkg](https://officecdn-microsoft-com.akamaized.net/pr/C1297A47-86C4-4C1F-97FA-950631F94777/MacAutoupdate/Microsoft_Word_16.45.21011103_Installer.pkg)
> * [Update history for Office for Mac](https://docs.microsoft.com/en-us/officeupdates/update-history-office-for-mac)
> * [Release notes for Office for Mac](https://docs.microsoft.com/en-us/officeupdates/release-notes-office-for-mac)
> * [Activate Office 2019 for macOS VoL.md](https://gist.github.com/zthxxx/9ddc171d00df98cbf8b4b0d8469ce90a)
> * [Uninstall Office for Mac](https://support.microsoft.com/en-us/office/uninstall-office-for-mac-eefa1199-5b58-43af-8a3d-b73dc1a8cae3?ui=en-us\&rs=en-us\&ad=us)
> * [Release history for Microsoft Auto Update (MAU)](https://docs.microsoft.com/en-us/officeupdates/release-history-microsoft-autoupdate)

> Q\&A
>
> * ["There is a problem with your account. Try again later." - Mac (Sierra)](https://answers.microsoft.com/en-us/msoffice/forum/msoffice_word-mso_mac-mso_o365b/there-is-a-problem-with-your-account-try-again/b4e821b5-4163-40c5-99c3-230bb1db2161)
> * [Office 365 Business won't activate on Mac](https://answers.microsoft.com/en-us/msoffice/forum/msoffice_account/office-365-business-wont-activate-on-mac/51a3e684-4d7a-4993-b112-197941ea8601)
> * [How to troubleshoot issues that you encounter when you sign in to Office apps for Mac, iPad, iPhone, or iPod Touch when using Active Directory Federation Services](https://support.microsoft.com/en-us/office/how-to-troubleshoot-issues-that-you-encounter-when-you-sign-in-to-office-apps-for-mac-ipad-iphone-or-ipod-touch-when-using-active-directory-federation-services-e44357b4-c9c4-4580-a946-ef5dabdb98cd?ui=en-us\&rs=en-us\&ad=us)
{% endhint %}

### office

[**uninstall completely**](https://answers.microsoft.com/en-us/msoffice/forum/all/microsoftoffice161618081201installerpkg-download/09eb6c6b-8615-4c6e-93cf-4bba4f7dcac3)

> If you still meet the issue, I suggest you try the following steps and resign into Office to check the result: Navigated to Library folder and open Group Containers. Ctrl+click each of these folders if present, and Move to Trash.
>
> ```bash
> UBF8T346G9.ms
> UBF8T346G9.Office
> UBF8T346G9.OfficeOsfWebHost
> ```
>
> Warning: Outlook data will be removed when you move the three folders listed in this step to Trash. You should back up these folders before you delete them.

{% hint style="info" %}
> references:
>
> * [pbowden-msft/Unlicense](https://github.com/pbowden-msft/Unlicense/blob/master/Unlicense)
> * [\[FIX\] Error When Opening Word or Outlook on Mac (EXC\_BAD\_INSTRUCTION)](https://appuals.com/exc_bad_instruction/)
> * [How to remove Office license files on a Mac](https://support.microsoft.com/en-us/office/how-to-remove-office-license-files-on-a-mac-b032c0f6-a431-4dad-83a9-6b727c03b193)
> * [Having problems with Office and Outlook for Mac 2016 (Sept/Oct 2017)](https://www.itguyswa.com.au/problems-with-outlook-for-mac-2016-solved/)
{% endhint %}

```bash
$ ls -1d ~/Library/Group\ Containers/UBF8T346G9.*/
/Users/marslo/Library/Group Containers/UBF8T346G9.Office/
/Users/marslo/Library/Group Containers/UBF8T346G9.OfficeOneDriveSyncIntegration/
/Users/marslo/Library/Group Containers/UBF8T346G9.OfficeOsfWebHost/
/Users/marslo/Library/Group Containers/UBF8T346G9.OneDriveStandaloneSuite/
/Users/marslo/Library/Group Containers/UBF8T346G9.com.microsoft.rdc/
/Users/marslo/Library/Group Containers/UBF8T346G9.ms/
```

### outlook

#### profiles

*   [profile](https://answers.microsoft.com/en-us/msoffice/forum/msoffice_outlook-mso_mac-mso_365hp/where-is-the-microsoft-database-utility-in-mac/205f7e0a-153d-40dc-bafe-23485bedda01)

    ```bash
    $ ls ~/Library/Group Containers/UBF8T346G9.Office/Outlook/Outlook 15 Profiles/
    ```
*   [reset outlook profile](https://answers.microsoft.com/en-us/msoffice/forum/msoffice_outlook-mso_mac-mso_o365b/how-to-create-new-profile-in-outlook-for-mac/7af4acf5-7f02-486b-9d6c-ae9f6f941ea8)

    ```bash
    $ open "/Applications/Microsoft Outlook.app/Contents/SharedSupport/Outlook Profile Manager.app"
    ```

### word

> \[!TIP|label:references]
>
> * [office软件出现输入字延迟，点击延迟的现象](https://blog.csdn.net/A_zhangpengjie/article/details/107465113)
> * [\* Show document content (text animation, drawings and text boxes) in Word](https://www.extendoffice.com/documents/word/946-word-show-text-animation-drawing-text-boxes.html#a2)
> * [How to disable the smooth moving cursor in Office 2016](https://www.dedoimedo.com/computers/office-2016-smooth-cursor-disable.html)
> * [Typing Animation - Unbelievably annoying and can't turn off](https://answers.microsoft.com/en-us/msoffice/forum/all/typing-animation-unbelievably-annoying-and-cant/d011514a-c915-474a-90df-27649386bc4f)
> * [How to Disable the Typing Animation Feature in Office 2013](https://www.howtogeek.com/161826/how-to-disable-the-typing-animation-feature-in-office-2013/)
> * [How to Disable the Typing Animation in Office 2016 or Office 2013](https://www.laptopmag.com/articles/office-2013-typing-animation-disable)

#### logs

*   word: `~/Library/Containers/com.microsoft.Word /Data/Library/Caches/Microsoft/uls/ Com.microsoft.Word /logs`

    ```bash
    $ tail -f ~/Library/Containers/com.microsoft.Word/Data/Library/Caches/Microsoft/uls/com.microsoft.Word/logs/apple-device-log-20210114-2301.log
    ```

#### disable animations

```batch
> cat DisableAnimations.reg
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\SOFTWARE\Microsoft\Office\16.0\Common\Graphics]
"DisableAnimations"=dword:00000001
```

### powerpoint

> \[!TIP|label:references]
>
> * template location in mac (Version 16.94 (25020927)): `"$HOME/Library/Group Containers/UBF8T346G9.Office/User Content.localized/Templates.localized"`

#### create and add new template

* open pptx file with `PowerPoint`
* `File` -> `Save As` -> `PowerPoint Template (*.potx)`
* restart the _PowerPoint_

#### import new template

* copy the template file ( `.potx` ) to `"$HOME/Library/Group Containers/UBF8T346G9.Office/User Content.localized/Templates.localized"`
* open _PowerPoint_ -> `File` -> `New from Template` -> `Personal` -> choose the template

### excel

#### shortcuts

> \[!NOTE|label:references:]
>
> * [Excel Shortcuts “Cheat Sheet”](https://www.wallstreetprep.com/knowledge/excel-shortcuts/)
> * [Excel Shortcuts PC Mac](https://corporatefinanceinstitute.com/resources/excel/excel-shortcuts-pc-mac/)
> * [三种方法，教你在Excel里面给字体添加删除线](https://zhuanlan.zhihu.com/p/46124552)

|              SHORTCUT             | PURPOSE           |
| :-------------------------------: | ----------------- |
| <kbd>control</kbd> + <kbd>5</kbd> | strikethrough     |
| <kbd>command</kbd> + <kbd>1</kbd> | Open Format Cells |
