Skip to main content
Best answer

Microsoft Excel: The App returned “Could not obtain a WAC access token."


MarcusH

I have a Zap that has been set and forget for years.  Its essentially a trigger that then adds a new line to EXCEL and populates data.  Pretty simple.

 

Over the last few days I have been getting this error emailed to me: The App returned “Could not obtain a WAC access token."

I cannot see what the issue is, any suggestions?

Best answer by BremBest answer by Brem

Hi @MarcusH 

I’m sorry to hear that it didn’t fix the issue. Looking at this, it appears you are running into a bug in this app. I have added you as an additional vote for this to be fixed, and once it gets fixed, we’ll send you an email to let you know!

Additionally, I suggest using Google Sheets as a workaround for the time being.

Hopefully, it helps!

View original
Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

23 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @MarcusH 

Good question.

Check your Excel Zap app connection here: https://zapier.com/app/connections


MarcusH
  • Author
  • Beginner
  • 9 replies
  • March 19, 2023

Sorry, there is noting in your message


Troy Tessalone
Forum|alt.badge.img+14

@MarcusH 

Check your Excel Zap app connection here: https://zapier.com/app/connections


MarcusH
  • Author
  • Beginner
  • 9 replies
  • March 20, 2023

Thanks Troy, All tests were successful however I am still getting the error message email from Zapier each time there is a new ZAP.  

The ZAPs appear to be working but I get the email error.

Its a bit of a mystery

 


Troy Tessalone
Forum|alt.badge.img+14

@MarcusH 

Have you tried reconnecting the Excel Zap app connection?


MarcusH
  • Author
  • Beginner
  • 9 replies
  • March 20, 2023

@Troy Tessalone - thanks, I will give that a try.


Brem
Forum|alt.badge.img+6
  • Zapier Staff
  • 404 replies
  • March 20, 2023

Hi @MarcusH 

Let us know how it goes! 😊


MarcusH
  • Author
  • Beginner
  • 9 replies
  • March 20, 2023

@Brem it didnt fix the issue.  i am still getting the error alert emails


Brem
Forum|alt.badge.img+6
  • Zapier Staff
  • 404 replies
  • Answer
  • March 20, 2023

Hi @MarcusH 

I’m sorry to hear that it didn’t fix the issue. Looking at this, it appears you are running into a bug in this app. I have added you as an additional vote for this to be fixed, and once it gets fixed, we’ll send you an email to let you know!

Additionally, I suggest using Google Sheets as a workaround for the time being.

Hopefully, it helps!


MarcusH
  • Author
  • Beginner
  • 9 replies
  • March 20, 2023

Thanks @Brem 

I dont understand what you mean by an additional vote.  Using Google sheets isnt an option for me.  Ive been using Excel for years with this ZAP and never had any issues.  Do you know when this will be fixed?


Warden George

I am having exactly the same problem with 4 zaps.  Its intermitent but happening regularly


Danvers
Forum|alt.badge.img+12
  • Zapier Staff
  • 3731 replies
  • March 20, 2023

Hi @MarcusH!

We track the number of users affected by a particular bug to help us prioritize work on the app integrations that Zapier owns. I don’t have a specific date as to when this bug will be fixed, but I can say that currently there aren’t many affected users, so it’s not something that I would expect to be fixed in the immediate future. I know that’s not a great answer for you, I’m sorry about that.  

Some users have found that the Zap run works if you replay it in the Zap history, could you give that a go and see if it helps?

@Warden George, I have added you as an affected user on the issue report as well, which lets the team know how many people are affected and also means that we’ll send you an email if there’s an update. 


Bikashjena

I have the same issue with excel connection: The app returned "Could not obtain a WAC access token.".


MarcusH
  • Author
  • Beginner
  • 9 replies
  • March 20, 2023

@Danvers @Brem 

This has now morphed into the below error and the ZAPs dont even complete now. I have logged a couple of tickets with support and I havent had a response.  

 

Excel

The app returned "Tenant does not have a SPO license.".

 


sgibbs
  • Beginner
  • 2 replies
  • March 20, 2023

I have the same issue with excel connection: The app returned "Could not obtain a WAC access token.".

 

It was working fine this morning.


MarcusH
  • Author
  • Beginner
  • 9 replies
  • March 20, 2023

@Danvers @Brem

looks like there are more and more users getting the same issue.  Can we get this escalated?


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • 2653 replies
  • March 21, 2023

Hey there, @Bikashjena and @sgibbs - sorry to hear you’re running into this too!

I’ve gone ahead and added you to the list of impacted users that Danvers referenced. We’ll be sure to keep you in the loop if anything changes regarding a fix.


christina.d
Forum|alt.badge.img+9
  • Zapier Staff
  • 2653 replies
  • March 21, 2023

The app returned "Tenant does not have a SPO license.".

Hey there, @MarcusH. I did some digging and it looks like this may be related to something different.

This error pops when our Excel integration returns the "Tenant does not have a SPO license" error if there's an issue with an Office 365 account. Could I ask what type of account you currently have?
 
Right now, only the Office 365 Business account will work with Zapier - can you confirm that’s the type of account you have? 

According to our Excel connection guide here, only OneDrive for Business is currently supported and able to integrate with Zapier. Federated accounts, consumer accounts, Outlook accounts are not.

Keeps us posted!


MarcusH
  • Author
  • Beginner
  • 9 replies
  • March 21, 2023

Its a office personal account.  I have been Zapping for years!


Danvers
Forum|alt.badge.img+12
  • Zapier Staff
  • 3731 replies
  • March 21, 2023

Hi @MarcusH 

I can see that the Support Team replied to your ticket, and you’re in conversation with them. In this case, it will be best to keep the conversation going over with them. The Support Team can dig into the error logs of your Zap with you to look for the cause of the errors. 

 

Thanks!


jsn
  • New
  • 1 reply
  • March 21, 2023

I too am having this issue. 


MarcusH
  • Author
  • Beginner
  • 9 replies
  • March 21, 2023
Danvers wrote:

Hi @MarcusH 

I can see that the Support Team replied to your ticket, and you’re in conversation with them. In this case, it will be best to keep the conversation going over with them. The Support Team can dig into the error logs of your Zap with you to look for the cause of the errors. 

 

Thanks!

I have to say that the support is quite poor here.  As a paid subscriber for 6+ years that the response times are way too slow.  I have logged a ticket and it takes 24 hours to get a response and then when you reply to the support person with the answers they have asked for it resets and then it takes another 24 hours.

 

As you can see now there are many users impacted by this so It would be nice if this could be escalated.

 


JammerS
Forum|alt.badge.img+6
  • Zapier Staff
  • 2486 replies
  • March 22, 2023

Hi @jsn 

I’ve added you to the list of affected users, and we’ll  notify you via email once an update is readily available. Thanks.