I have this exact SAME problem on 2 different computers running Office 365 Family. What does the error message mean (in human terms) and how can it be fixed? Frustrating as h to spend 2 hours tinkering and serching for a solution? Is it just bug ridden and not ready for prime time? Is MSFT able to support people who actuall are willing to give Money in Excel a try?
From MS Forum:
Money in Excel does not login
I have a long standing subscription to Office 365. I downloaded the Money in Excel plugin and tried to run it. Although I was already signed in the Excel application, the add-in asked me to sign-in. In the sign in screen that appeared I entered my credentials, then a security screen came up asking me for my pin, and then... nothing!!! The window on the right of the screen remained blank with a small sing-in message above and an almost half way progress bar which was not moving!
In my second attempt, when the sign in screen came up I chose "Sign-in Options" and following the prompts I arrived at the following error message...
Message: AADSTS500202: User account *** Email address is removed for privacy ***' from external identity provider 'live.com' is not supported for API version '2.0'. Microsoft account pass-thru users and guests are not supported by the tenant-independent endpoint.