Hi there @Bestbooks 

The bug report has been closed so I’m unable to add you to it. I’d recommend contacting our Support Team here to have them investigate this further. They’ll be able to dig into the logs for your account and determine whether the issue has since resurfaced or if there’s a separate issue affecting your account from being connected.

Please do keep us in the loop on how you get on with them.

I am having the same issues and I have reconnected multiple times and even tried a different Microsoft account but it still does not work, please add me to the list for the bug as well, thank you!

Sorry to hear it’s not working still @restigian. Looking at the screenshot you sent it doesn’t appear that your Microsoft Excel account was reconnected. It looks like it’s using the same account connection that was added a month ago:

Can you reconnect your Microsoft Excel account and then try re-selecting the spreadsheet and worksheet in the Zap?

Keen to ensure you’re all set here so please keep us updated on how that goes! 

It doesn’t work for me

Still no forlder/sheet available and the connection works fine

Hi everyone, 

After an update from Microsoft, we believe this issue is resolved. 

To get your Zaps working again, please try the following:

1. Reconnect your Excel account
2. Re-select the Spreadsheet from from dropdown (and Worksheet if necessary)

After following these steps, you should be clear to resume mapping/testing the affected step or to turn the Zap on and run it.

We really appreciate your patience as we’ve worked with Microsoft. If the above does not work and you continue to see errors, please let our Support team know, and we’ll do everything we can to help.

Sorry you’re also being affected by this @natesheets. I’ve added you to the bug report as well so that we can notify you once it’s been resolved.

As has been mentioned earlier in this thread this issue is not limited to Zapier, and appears to be caused by a change on Microsoft’s end that’s surfacing these errors for workbooks on consumer OneDrive accounts.

However, as Connor mentioned, if you’re seeing these errors with workbooks stored on a OneDrive Business account, Group drive, or Sharepoint account please can you reach out directly to our Support team here to flag this. That will allow them to obtain the error logs for your affected Zaps so we can share these with the Microsoft team for further investigation.

UGH. Seeing that this has been an issue for months and is still unresolved is maddening. It stopped working for me today, randomly. Please add me to the list to be notified when it is fixed, but in the meantime I’ll need to look into alternatives to Zapier because my livelihood depends on this working. 

Hi everyone,

Connor from Zapier’s Support Engineering team here. I apologize for the sparse updates, and I really appreciate your patience we as we’ve dug into this.

As @SamB mentioned above, this issue is not limited to Zapier and its cause looks to be a change on Microsoft’s end, apparently related to the account on which the worksheet is stored—specifically consumer OneDrive accounts.

At this time we’re unable offer an ETA on the resolution. However, we are working with Microsoft to better understand the issue and the path forward.

Here is the most recent update from Microsoft:

We are working on a mitigation but unfortunately have no timelines to share at this point.
According to our investigation, this issue only happens for Workbooks stored in OneDrive Consumer platform. Please note Workbooks stored in OneDrive Consumer platform are not officially supported by Excel Graph...We recommend you to use Excel workbooks stored in OneDrive for Business, SharePoint site or Group drive if you would like use Excel Graph with full support.

If you’re currently experiencing this error with a OneDrive Business account, Group drive, or Sharepoint account, please let our Support team know.

We appreciate your understanding, and we’ll continue to do everything we can to push for a solution here. We will keep this thread updated with more information as we receive it.

Hi @tomo 

Thanks for taking the time to share this candid feedback with us. I’m sorry the Support you’ve had on this so far has not been as good as it should have been. I’ve passed your comments here over to the relevant teams so that we can improve upon the information and communications shared regarding bugs in future. I can see that the Support team have already added you to the bug so we’ll definitely reach out to you, and everyone else who’s being affected by this, as soon as it’s been resolved on Microsoft’s end.

To clarify, we are not in any way trying to push folks towards using a paid add-on for Zapier Tables. This issue is not exclusive to Zapier. Microsoft’s own API needs to be fixed in order for the Microsoft app integration that uses it to resume working correctly, unfortunately this isn’t something we can fix from our side. 

I understand how frustrating this must be for everyone here and I would recommend setting up an interim workaround of moving a copy of your affected Excel workbooks over to a different spreadsheet app and use the alternative app instead for the time being. Then later once the issue has been resolved you can move back to using Excel. We have a number of different spreadsheet apps available (doesn’t have to be Zapier Tables!) which you can view here: https://zapier.com/apps/categories/spreadsheets. I do hope that helps to get your workflows up and running again in the meantime.

Thanks for everyone's ongoing patience and understanding on this. As soon as we get any updates on the situation I’ll be sure to let you all know here!

This is a joke

This bug is messing up my automation for many months already. Had to do task manually, which can cause errors.

I am behind some of my admin tasks because of it.

The reply is the same, and has not changed for months. One of the most popular software, and widely used is completely ignored. My guess: the paid add-on of Tables they want you to use as much as possible instead of excel.

Zapier support is taking a right on pi$$ with this. And not only with this one. NONE of the bugs I reported has been resolved.

Shame on you Zapier. Tech support : 0-10!

I have already scaled down my integrations using Zapier and will be looking to migrate to a different integration software.

Sorry to hear that @lenzomio. I’ve added you to the list so you’ll be notified once it’s resolved.

It’s very odd that it was working until July 2nd but has since stopped. I’d recommend reaching out to our Support team here for further investigation into that. I’m hopeful that they might be able to find some helpful clue in the logs for your Zap that may help to give an indication of what recent change was made to stop it working suddenly. 

In the meantime, can you confirm whether your Zaps are connected to Excel workbooks on a personal OneDrive account, Business OneDrive account, SharePoint site or Group drive? Thanks!

I have the same problems!

Hi @cbc 

Thanks for the update.  So just to confirm the Microsoft API is causing all EXCEL/ZAPIER integrations to have issues ? 

As I understand it, these errors are caused by an issue with the Microsoft’s API itself, not the Microsoft Excel app integration on Zapier. I’d expect folks using Microsoft Excel’s API independent of Zapier would also be running into similar issues. 

There is no workaround at the moment apart from using SHEETS ?

Google Sheets isn’t the only alternative. You could can see the full list of other spreadsheet-type of apps available to use with Zapier here: https://zapier.com/apps/categories/spreadsheets. 

How long do these things usually take to resolve? 

There isn’t a set amount of time that it usually takes. Issues can vary greatly in complexity and it’s not always clear how long they will take to resolve. The issue itself will need to be fixed on Microsoft’s end so it might be worth reaching out to them directly to see if they are able to offer any insight on how long they expect a fix to take.

 Also its been unclear also about the start date of these problems?  Was it indeed May ? It was MAY for me - but others have mentioned april/march etc ?

I don’t have a confirmed date for when it began. But this Community thread was started back in February so it appears it was earlier than May.

Looking at the Microsoft Q&A site it seems others are running into similar errors here: https://learn.microsoft.com/en-us/answers/questions/1688063/error-401-fileopenuserunauthorized-graph-api. It was noted in the thread there that this issue was occurring for worksheets on personal OneDrive accounts. So I did some further digging and according to the documentation on Microsoft's API here it can be used to read/modify Excel workbooks stored in a OneDrive for Business, SharePoint site or Group drive - there’s no mention of personal OneDrive accounts. Perhaps this wasn’t always the case and is why now seeing these errors in cases where Zaps were working previously? 

Can anyone in the thread here confirm whether these “You do not have permissions to open this file in the browser” errors are also occurring for workbooks on a OneDrive for Business, SharePoint site or Group drive?

Hi Sam

Thanks for the update.  So just to confirm the Microsoft API is causing all EXCEL/ZAPIER integrations to have issues ? 

There is no workaround at the moment apart from using SHEETS ? How long do these things usually take to resolve?   Also its been unclear also about the start date of these problems?  Was it indeed May ? It was MAY for me - but others have mentioned april/march etc ?

Regards

Hi @cbc and @yasinyaso,

I’m very sorry about the frustrations caused by this issue, I’ve just checked on the bug report again and it’s still unresolved. I can’t make any promises around when it will be fixed but you both will definitely be notified by email once it is.

To clarify, these “You do not have permissions to open this file in the browser” errors are due to an issue with the Microsoft’s API itself so it’s not just the Microsoft Excel app on Zapier that is being affected here. This means that the issue with Microsoft’s API will need to be resolved on Microsoft’s end to get things working again. Our team is in communications with Microsoft and we’ll do all we can from our side to help in get this resolved. Thanks for everyone’s continued patience on this in the meantime. 

What is happening here? 
its very frustrating we cant work with excel :-(

Still no update team - there must be multiple posts now advising of excel issues.  This is a show stopper for me and has been since early may. 

Surely this means anything excel related isnt working at the moment.  

I really really really dont want to move sheets.  Ive had these zaps working fine with excel for over a year (on a daily basis!!)

Sorry to hear that @RBSG. Looks like our Support team has already added you to the list of folks being affected here. I can’t give any estimate as to when it will be fixed unfortunately, but you’ll definitely be notified once it is.

Hi,

I have the same issue there. i have trying everything and still doesn’t

This issue affects our workflow quite badly.

Please help

Hi @ld2024, thanks for letting us know that you’re being affected by this as well. I’m sorry to not have any workarounds to suggest on this. I’ve added you to the list so we can send you an email notification as soon as it’s been sorted. 

Add me to the list as well. This is the biggest use case for me and Zapier can’t display the worksheet although I have gone through every solution presented in this and similar threads.

I’m so sorry you’re also experiencing this issue, @Scham Matthias. I’ve added you to the list as well so you’ll definitely get an email notification once it’s been fixed.

Hello @SamB I also wanted to Try out this Feature but sadly I also have this Problem. Can I also be added to the E-Mail notivication? Thank you in advance.

Sure thing, @hercules! I’ve added you to the list now, so you can expect an email notification from us once it’s resolved.