Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Question

Microsoft Excel error: Unable to load choices. We're having trouble loading 'Worksheet' data.

  • January 24, 2024
  • 1 reply
  • 123 views
CasparSmits

Hi all,

I'm experiencing an issue where Zapier cannot load Excel data. It gets an error (“Unable to load choices
We're having trouble loading 'Worksheet' data. Unable to process request. Learn more about this error: http://zpr.io/6a6q8”) and if I select the worksheet using the ID, it cannot load the columns either (“Unable to load choices
We're having trouble loading 'Lookup Column' data. Unable to process request. Learn more about this error: http://zpr.io/6a6q8”). If I put in a col number manually and run the zap, it will error: “Failed to find or create a find row in Microsoft Excel
Unable to process request. Learn more about this error: http://zpr.io/6a6q8”

The link doesn't provide much help. The excel file is on OneDrive and is 19MB of size. It feels as if it's unable to get any access to the contents of the file. The name hasn't changed, the file is created by the same owner that logs into OneDrive through Zapier. Does anyone know what else I could do/check to fix it?

Best,

Caspar 

 

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

1 reply

Troy Tessalone
Zapier Orchestrator & Solution Partner
Forum|alt.badge.img+14
  • Troy TessaloneZapier Orchestrator & Solution Partner
  • Zapier Orchestrator & Solution Partner
  • January 24, 2024

Hi @CasparSmits 

Did you already review the help articles for using Excel in Zaps for possible guidance?

https://zapier.com/apps/excel/help

 

The issue may stem from the size of the Excel file.

⚡ Troy Tessalone - AutomationAce.com | Platinum Zapier Solution Partner | #1 Zapier Community Contributor
Terms & ConditionsAccessibility statement