Best answer

Microsoft Excel error: The app returned "You do not have permission to open this file in the browser.".


Userlevel 2
Badge +1

Hi,

 

All steps that involve Excel are currently erroring in all my Zaps.

 

It's giving the error: The app returned "You do not have permissions to open this file in the browser.".

 

I've 'Tested' and 'Reconnected' Excel in Apps.

 

I've tried creating a new Zap with an Excel step (using both the existing and a newly added Excel connection) and it doesn't produce anything at the 'Worksheet' stage (having successfully selected a 'Spreadsheet').

 

It seems to be the same error detailed at https://community.zapier.com/troubleshooting-99/connecting-to-excel-is-giving-you-do-not-have-permissions-to-open-this-file-in-the-browser-32095

 

I've been in contact with Zapier help and they have only been able to suggest that I check the Share setting in Excel but all that seems to do is add an email got shared access or generate a share link a I don't see how that would help.

 

Any help with what to do to get this working would be appreciated :)

 

Jon

icon

Best answer by ken.a 21 March 2024, 10:26

View original

38 replies

I created a new Microsoft account, copied my files in a new one drive and reconnected everything. Works fine.

Userlevel 1

Since Microsoft and Zapier have no solution for months!, I created my own: By using a new microsoft account, I could resolve this issue for all zaps.

A new Microsoft account ?  How do you mean.  My excel file is based in One Drive on my personal microsoft account. 

 

Mine only stopped working at the end of May.

Since Microsoft and Zapier have no solution for months!, I created my own: By using a new microsoft account, I could resolve this issue for all zaps.

Userlevel 1
Badge

Same issue for me:

 

 

Userlevel 1

I have also reported multiple excel issues!  All stopped working in the last few weeks.  EVERYTHING EXCEL IS BROKEN. 

I dont understand there is so many people with sudden issues, why is it not fixed yet. 

Userlevel 7
Badge +6

Hi @Zweitoechter, @John_CMA, and @gwennie363,

I’m so sorry for the late response here.

I have added you all as another affected members of the bug report. We will keep you updated via email once the bug has been fixed.

I appreciate your patience and understanding.

Same, this just started happening to me as well 05/23/2024. No changes have been made to my Zapier or OneDrive account (unless M.Soft or Zapier made changes without acknowledging them). Have been unable to solve the error. 

Hi @ken.a,
Pls add me to the open bug report. I have several Zaps that send data to Excel. Most of these Zaps have been working quite well for more than a year. As of May 3, 2024, all of my Zaps that send data to Excel stopped working, and started returning the same error message “Error: Excel Error: You do not have permissions to open this file in the browser.” 
As a response, I’ve reconnected all related apps, and verified all permissions. I was somewhat under the impression that this was related to a recent Windows update that I ran, but after reading this forum I’m not so sure. Please Help!

Hello, I have the same problem as of today. All my zaps connected to Microsoft Excel are not working anymore.

The app returned "You do not have permissions to open this file in the browser.".

Please help! 

I did not have existing Zaps, but from a new Zap journey. I was able to resolve this error when I realized that you need ot be on Office 365 Business account vs a personal plan. Once I swapped to my business account this resolved the error!

Hope this helps someone, because it took hours away from me!

Userlevel 7
Badge +6

Hi @Chnkx,

I have added your email address to the open bug report. We will keep you in the loop via email once the bug has been fixed.

I appreciate your patience and understanding.

@ken.a could you please add me to your email list as well? I have the same error with my excel sheets.

 

 

 

Userlevel 7
Badge +6

Hi @Olimpo,

I have added you to the open bug report as another affected member. We will keep you updated via email once the bug has been fixed.

I appreciate your patience and understanding.

I’m afraid the same issue is happening to my zaps since about 4 weeks ago. I guess Zapier Team hasn’t fixed it yet...

Userlevel 7
Badge +6

Hi @pancuk,

I have added you to the open bug report. We will keep you in the loop via email once the bug has been fixed.

I appreciate your patience and understanding.

Hi @ken.a i am also having this issue it started on the 12th of April for me can i be added to this email to let me know when fixed please, or has there been a fix?

 

Thanks 

Userlevel 7
Badge +6

Hi @cjk_sm and @martynelvis,

I have added you to the open bug report as another affected members. We will keep you updated via email once the bug has been fixed.

I appreciate your patience and understanding.

I too am getting the same errors on excel . 

Hi @Cjking,

I have added you to the open bug report as another affected member. We will keep you updated via email once the bug has been fixed.

@UXD, our engineers are still looking into the issue.  For reference, I don’t have a timeframe on how long it normally takes to fix bugs because there are multiple variables at play. 

We consider the complexity of the bug, how many users are affected, and the scope of the issue when we prioritize issues. It also depends on whether the issue cause lies solely in our control or if we need to work with our partners at other apps to resolve it, so the timeframe can range. 

I appreciate your patience and understanding.

Hey @ken.a,
I’ve been having the same trouble as them, my zaps are all error-ing out with the same error. Please add me to the list of affected users! We appreciate any solutions you might be able to provide!
Thanks!

Userlevel 7
Badge +6

Hi @Cjking,

I have added you to the open bug report as another affected member. We will keep you updated via email once the bug has been fixed.

@UXD, our engineers are still looking into the issue.  For reference, I don’t have a timeframe on how long it normally takes to fix bugs because there are multiple variables at play. 

We consider the complexity of the bug, how many users are affected, and the scope of the issue when we prioritize issues. It also depends on whether the issue cause lies solely in our control or if we need to work with our partners at other apps to resolve it, so the timeframe can range. 

I appreciate your patience and understanding.

Userlevel 2

Any Updates so far? Nearly a month without a solution… 

Hi, 

I also encountered this error in another google sheet add on for insertion of a new row from a google sheet to an excel file in microsoft’s one drive. It worked well one day and then the next day I get the error: 

Error: Excel Error: FileOpenUserUnauthorized - You do not have permissions to open this file in the browser. ?$select=id,name

Could it be an issue with microsoft excel?

 

I hope this can be sorted out soon.

Cheers,

Cjking

Userlevel 7
Badge +6

Hi friends,

Our Support Team created a bug report regarding the “You do not have permission to open this file in the browser” error. Our team is aware of the issue and is working on a fix. I've added your email address as another affected user. That does a few things:

  • Bring this to the attention of the integration developers
  • Help track and prioritize fixes
  • Allows us to notify you via email if/when this is fixed

Unfortunately, I do not have an ETA, but I’ve added you to the list of users affected by this issue so we can let you know as soon as we have any updates.

I appreciate your patience and understanding.

Userlevel 1

@Jon Hall and @UXD 

You can try opening a ticket with Zapier Support: https://zapier.com/app/get-help

 

I've had a ticket open for over 8 days and we're not getting anywhere at the moment I'm afraid 😓

I’m having the same issue.  It started with one zap, then the next day another zap, then finally all of them are erroring out.  Zap support is taking forever!!!

Userlevel 2

Ticket is since two days open. My customers getting crazy and I don't get a response...

Reply