Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Excel add-in not updating for some clients #4415

Open
3 tasks
bferreira opened this issue May 1, 2024 · 7 comments
Open
3 tasks

Excel add-in not updating for some clients #4415

bferreira opened this issue May 1, 2024 · 7 comments
Assignees
Labels
Area: Excel Issue related to Excel add-ins Needs: attention 👋 Waiting on Microsoft to provide feedback

Comments

@bferreira
Copy link

bferreira commented May 1, 2024

Provide required information needed to triage your issue

We provide an excel add-in to our clients: https://appsource.microsoft.com/en-us/product/office/wa200000126?tab=overview
We have updated the authentication. There has been a change on the manifest about 1 month ago and we have now also changed the Javascript and HTML files.
Some are able to login and access the add-in as normal but other users are stuck on the login.
The ones stuck have reinstalled the login and have also tried to clean the cache as explained here: https://learn.microsoft.com/en-us/office/dev/add-ins/testing/clear-cache#manually

They are able to access and login to our webpages that use the same system.
Also we have customers in different countries in Europe and also Japan, reporting this problem

Your Environment

  • Platform [PC desktop, Mac, iOS, Office on the web]:PC desktop
  • Host [Excel, Word, PowerPoint, etc.]: Excel
  • Office version number: Office365,Office2016 and 2019 (but works on some)
  • Operating System: Windows 10 and 11
  • Browser (if using Office on the web): not using it

Expected behavior

Open the add-in and see the login page:
image

Current behavior

When open the excel add-in, the screen that used to display is no longer available, it shows the redirect message and now only a blank white screen appears.
image

Steps to reproduce

  1. Open Volue Insight API excel Add-in
  2. Instead of displaying the login page it displays a blank page

Link to live example(s)

  1. link to the add in https://appsource.microsoft.com/en-us/product/office/wa200000126?tab=overview


Provide additional details




Context

We have migrated to a new authentication solution and our users are not able to see the new login page to login

Useful logs

  • Console errors
  • Screenshots
  • Test file (if only happens on a particular file)

Thank you for taking the time to report an issue. Our triage team will respond to you in less than 72 hours. Normally, response time is <10 hours Monday through Friday. We do not triage on weekends.

@m-hellesen
Copy link
Collaborator

Hi there, thanks for reporting. For clarification: Are you reporting that the add in is not getting updated for some users? Or is this that the html is not updated? Can you provide more details about how the users are getting this blank screen? This is within the add in code, so I want to see how I can help.

@bferreira
Copy link
Author

bferreira commented May 8, 2024

Hi, I don't have access to all the computers, but from the only one I could see, I didn't see any errors on the console.
I don't have access to the computer anymore but I can ask for a session.
What should I look for? Is there a way to force the update of all files?

@bferreira
Copy link
Author

I got more screenshots from a client. I don't think they are getting the latest version of the add-in. Although it says it is:
Screenshot 2024-05-08 at 12 22 22

When then install they get:
Screenshot 2024-05-08 at 12 12 14
On the manifest I have all the urls authorized:
image

@m-hellesen
Copy link
Collaborator

Are you attempting to launch a dialog with your auth flow? Can you tell me how that flow works? What files do you believe are missing?

@bferreira
Copy link
Author

bferreira commented May 8, 2024

No we don't attempt to launch the dialog.
Opening a separate window has been the issue.

We use https://auth0.com/docs/get-started/authentication-and-authorization-flow/authorization-code-flow-with-pkce
It is working fine in some machines, using different login methods (Microsoft, google, Email)
You can login yourself with your Microsoft account, you just won't get any data

@bferreira
Copy link
Author

The only dialog window we have was because Microsoft made us support office online
When we get the callback from auth we do:


import { AuthIdentityService } from '../Utils/authIdentityService';

(() => {
  Office.initialize = () => {
    const authService = new AuthIdentityService();
    authService.loginCallback().then(() => {
      const isDialog = Office.context?.platform === 'OfficeOnline';
      if (isDialog) {
        window.location.href = '/excel-plugin/login.html';
      } else {
        window.location.href = '/excel-plugin/index.html';
      }
    });
  };
})();

But it does not get there.

@bferreira
Copy link
Author

In cases the solution is to log out from office account, restart office and log-in again.
I guess Microsoft account in office doesn't do well with logging in with microsoft account on the add-in.

I still have some 2016 office versions that the issues is not solved.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Area: Excel Issue related to Excel add-ins Needs: attention 👋 Waiting on Microsoft to provide feedback
Projects
None yet
Development

No branches or pull requests

3 participants