Clear recents list in Microsoft Office for MAC. Word Excel Powerpoint

Microsoft Office for MAC 2019 uses recents in Word, Excel and PowerPoint.  There is no option in the MAC version to clear out the whole list and users need to remove the recents one by one using "remove from recents".  Alternatively the following bookmark files can be deleted or renamed:

~/Library/Containers/com.microsoft.Word/Data/Library/Preferences/com.microsoft.Word.securebookmarks.plist

~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/com.microsoft.Excel.securebookmarks.plist

~/Library/Containers/com.microsoft.Powerpoint/Data/Library/Preferences/com.microsoft.Powerpoint.securebookmarks.plist

"Pending Upload" Microsoft Office for MAC 2019

Sometimes the sharepoint / onedrive files get stack with "Pending Upload" in office product like word, excel and powerpoint.

Snoop the files that word/excel/powerpoint is trying to open using:

sudo opensnoop | grep OfficeFileCache

Once the files are identified, delete/move or rename the files from the Cache directory:

~/Library/Containers/com.microsoft.Word/Data/Library/Application\ Support/Microsoft/AppData/Microsoft/Office/16.0/OfficeFileCache/0/0

~/Library/Containers/com.microsoft.Excel/Data/Library/Application\ Support/Microsoft/AppData/Microsoft/Office/16.0/OfficeFileCache/0/0

~/Library/Containers/com.microsoft.Powerpoint/Data/Library/Application\ Support/Microsoft/AppData/Microsoft/Office/16.0/OfficeFileCache/0/0

PS: Stop all running Apps eg: ClamXAV, LittleSnitch and others to reduce output from opensnoop.