Issue using all functionalities of embedded excel file

[Pat Breslin]

We use Confluence Cloud and I have embedded an excel file using  (Microsoft Excel + Confluence) macro. 

It allows for us to bring in an excel file and all of excels functions which is what we want...

When I "view full-sized workbook" via the button on the bottom right corner, it opens up fine but the data tab has the filter function greyed out. I assume I need to save a copy to my OneDrive in order to filter?

If that is the case, this is where I get an error... We are a local government agency which may or may not be playing a role in this issue.

I click on the button on the top right "Edit a copy" which then asks me to sign in to OneDrive. When I enter my email it comes back telling me that account doesn't exist.. This is only an issue via this login method... If I go to OneDrive.com and login with the same email then it works.

[Brant Schroeder]

@Pat Breslin I would suggest contacting the app vendor.  They should be able to provide some insight into how they provide authentication.