Skip to main content
Question

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

  • 24 January 2024
  • 1 reply
  • 68 views

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 

 

1 reply

Userlevel 7
Badge +14

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.

Reply