Sharepoint Connector - Error rectifying Excel File

Jbrorby

Hi. We have a sharepoint Excel file that we bring into Domo via the sharepoint connector. Today I got an error I've never seen before and couldn't find anything on Google about. "Error rectifying Excel file. Please try again later."

I double checked that the file has not moved or changed names or tab names and that the column names haven't changed. And usually if this were the case I get a different error message than the one above.

Could it be anything to do with the excel file using formulas in the fields? I'm not sure if they originally had it set up that way or not.

Domo Community.PNG

ArborRose

Yes, the error indicates there may be an issue with processing the Excel file. If you are sure on the location, name, tab names, and such…you might check formulas, file size (too large?), corrupt file, permissions, etc.

Can you test with the copy of the file without formulas? Copy the Excel file contents and paste back down with Paste Special > Values. And then see if that works to indicate whether formulas are the issue?

ArborRose

Yes, the error indicates there may be an issue with processing the Excel file. If you are sure on the location, name, tab names, and such…you might check formulas, file size (too large?), corrupt file, permissions, etc.

Can you test with the copy of the file without formulas? Copy the Excel file contents and paste back down with Paste Special > Values. And then see if that works to indicate whether formulas are the issue?