Problem in signing in office applications

I had already removed CleanMyMac few days ago.. do not know why it's still in the report..

The idea behind EtreCheck is to show you what software is installed in hidden locations and running in the background. Most 3rd party software listed on an EtreCheck report cannot be removed by throwing something in the trash. You must use a vendor-provided uninstallers or uninstallation instructins. CleanMyMac is still installed and running. Ironically enough, the part you removed was almost certainly the part that included the uninstaller functionality. If you manually deleted some part of it, then all you have done is left it in an unstable state. You will need to reinstall it and then remove it correctly.

I also suggest you review your hosts file and ensure that you aren’t redirecting any microsoft network requests. You have 152 entries. That is an unusually large number.

hosts is quite possibly the problem, here. Reset that to default, as John Galt mentions.

That file serves various uses, but some common uses of that file run afoul of software licensing and of network connectivity. Among the many apps that might, some malware and some sketchy code and some torrented and cracked apps will also use that file.

Reset that to default (using a command line editor, or using the free version of BBE (formerly TextWrangler) to modify the file, and reboot, and try the Microsoft Office tests again. Most ofnthe GUI text editors won’t work with that and similar system files.

Try a safe boot.

    Shutdown your machine.  Hold down the shift

key.  Poweron.  The boot up will take longer than normal

because the filesystem on the startup drive is being checked and

repaired as needed.   All about safe mode including what

features and apps safe boot leaves out. 

Safe boot uses a software driver instead

of using your machines video hardware.

http://support.apple.com/kb/ht1455

R

I found this recent Discussion on a Microsoft user support forum: Can't Activate My Office 2016 with my Office 365 Account. It describes your experiences pretty closely.

In case you are unable to access the above forum without signing in, the following is its most recent response. See if it offers anything that might work for you:

"I can verify the procedure does not work.

I still cannot activate Office 2016 16.16.7. Nor can I log into OneDrive through Office 16.16.7 apps.

Version 15.41 works fine.

I did another experiment. I uninstalled everything via the above procedure. I installed 15.41 Word and 16.16.7 Excel. I tried to activate through Excel and it did not work. I WAS able to activate through Word. I went back to Excel and I got the dialogue box for allowing MS to get bug reports. You can opt in or out. The dialogue box was unresponsive no matter what selection I made and I could NOT open Excel.

Then I uninstalled Excel 16.16.7 and reinstalled Excel 15.41. It opened and activated just fine and I can access OneDrive through it.

Now I can run the updater to update 15 to 16, and it will remain activated. However it will not allow me to log on to any online services through it like for the templates or for OneDrive. It either hangs or gives me the No Network Connection error.

Clearly something is wrong with the 16.16.7 update. I am sticking to 15.41 for now unless there is another update. And then I will on test on ONE app. I lost a whole day of productivity trying to sort out this mess.  "

Summary: it seems MSFT has a problem with that particular update, and if that's the case only they can fix it.

If the above workaround or solution doesn't work for you contact Microsoft again and let them know what you did in an effort to resolve it. Perhaps they will be interested in that Discussion, or this one.

Edit to add: It seems they're having a lot of similar complaints, with no resolution forthcoming:

Office 365 for Mac - Installs but stalls during the Sign In process

etresoft suggested reviewing that Mac's Hosts file. For more information read his User Tip, here: Fixing a hacked /etc/hosts file - Apple Community

To get an idea of what an unmodified Hosts file looks like, this is an example:

Last login: Mon Mar 11 23:00:55 on console
iMac22:~ john$ cat /etc/hosts
##
# Host Database
#
# localhost is used to configure the loopback interface
# when the system is booting.  Do not change this entry.
##
127.0.0.1	localhost
255.255.255.255	broadcasthost
::1             localhost 
iMac22:~ john$ 

I don't use any Microsoft products so I am not the best source for advice, but their suggestions certainly seem reasonable.

As I understand it, your Internet connection is clearly working despite Microsoft's "no network connection" dialog, and the problems persist even if you create another, temporary User Account. All I would read into that particular dialog is that your Office applications are unable to contact Microsoft for whatever reason. The troubleshooting steps you performed obviate many potential culprits.

That leaves the possibility of a potentially corrupted macOS installation, which can be addressed by reinstalling macOS: Reinstall macOS - Apple Support. It doesn't often fix anything but it's harmless enough to try.

Before you do that you might also try booting "Safe Mode", followed by rebooting normally, and determining if the problem persists: Use safe mode to isolate issues with your Mac

Needless to say, you are using any non-Apple "anti-virus", "cleaning", or "Internet security" junk, anything at all in that broad category of useless garbage, don't. A lot of things won't work if you do. If any of that sounds even remotely familiar please write back for suggestions.

Back up your Mac before making any changes to its file system. To learn how to use Time Machine please read Back up your files with Time Machine on Mac.

Antivirus apps: CleanMyMac

OMG

I wish you had told me about that.

As I wrote:

Needless to say, you are using any non-Apple "anti-virus", "cleaning", or "Internet security" junk, anything at all in that broad category of useless garbage, don't. A lot of things won't work if you do. If any of that sounds even remotely familiar please write back for suggestions.

First open Spotlight by selecting the magnifying glass at the top right of your desktop.

a. Search for and open Keychain.

b. In the search field, enter adal.

c. Check if there are items whose type is MicrosoftOffice15_2_Data:ADAL:<GUID>. If yes, select all, and then press Delete.

d. In the search field, enter office.

e. Select the items that are named Microsoft Office Identities Cache 2 and Microsoft Office Identities Settings 2, and then press Delete.

f. Quit Keychain Access.

g. Restart the Mac, open one Office 2016 for Mac application and then sign into it with your account to see the outcome.

*****

[Link Edited by Host]

MrHoffman's suggestion to try EtreCheck is worth considering.

In another Discussion someone else suggested looking for additional Microsoft entries in Keychain and deleting them, but I wouldn't know which ones to look for. There might not be any.

Already tried.. didn't work

Redundant answers happen on this site. Not much you can do about it.

done.. still not working

Having overlooked crucial information regarding "cleaning" products I suggest demonstrating a little more commitment to solving your problem before asking others to devote their time and effort toward helping you.

Explain what you did.

I asked others to help, hopefully from those still using Microsoft products. I don't know if or when anyone will be able to do that so all you can do is be patient. Of course you are welcome to create a new Discussion explaining what you did so far. That might elicit more interest.

Including a link to this one would help others understand what that was, so if you choose to do that copy and paste this: Problem in signing in office applications