Error: Object returned error code: 0x800AC472 -- unique to my computer

Hello,

I'm receiving the following errors when running a particular m-file. My colleague does NOT receive the same (or any) error messages when running the file from her computer. Does anyone have any initial thoughts about what might be causing the issue(s), and how to resolve it/them?

------------------------------------
Error using xlsread (line 247)
Error: Object returned error code: 0x800AC472

Error in ReadInputSheet (line 31)
   [~, ~, AllRawData{1, i}] = xlsread( strcat( InputSpreadsheetLoc, '\', InputSheetName), TabNames{ 1,
   i});

Error in RunStorageEvaluation (line 36)
ReadInputSheet(InputSheetName)

------------------------------------

I've tried searching (Google) on "Error: Object returned error code: 0x800AC472", but haven't found much to help me resolve this.

I realize that one might need more information about the m-file itself to determine what the issue is, but I thought I'd start by showing just the error code in case anyone has any thoughts based on that.

Thanks in advance,

Matt

Answer 1

[Dasharath Gulvady]

Matt, The 0x800ac472 error code is returned by Microsoft Excel when it is unable to process ActiveX requests.

Usually the cause is an opened dialog box in a running copy of Microsoft Excel. The error may also be due to some add-ons in Microsoft Excel.

The possible workarounds are: 1. Make sure that Excel is closed when you are importing Excel spreadsheet data. or 2. Use XLSREAD in basic mode to read Excel data. or 3. Disable add-ons in Microsoft Excel, and repair Microsoft Office.