error message: what is going on?

Dear all,

I use matlab 2011.

I get the following error message

 Error using
Interface.000208DB_0000_0000_C000_000000000046/Open
Invoke Error, Dispatch Exception:
Source: Microsoft Excel
Description: Microsoft Excel cannot access the file
'C:\wow2\oio.xlsx'.
There are several possible reasons:

 • The file name or path does not exist.
• The file is being used by another program.
• The workbook you are trying to save has the same name as a
currently open workbook.
Help File: xlmain11.chm
Help Context ID: 0

 Error in xlsread (line 248)
ExcelWorkbook = Excel.workbooks.Open(file,0,true);

I am trying to merge 46 excel files. the total size of the merged file is 5 milions rows by 25 columns.

could you tell me what the problem is?

thanks

[per isakson]

The error message includes three possible reasons. Why is it not one of these? Did you try to use a different name like, test17.xlsx?

[antonet]

I tried to reboot my pc. When I run the same code I got this new message

 Error: Not enough storage is available to complete this
operation.

 Error in xlsread (line 313)
 rawData = DataRange.Value;

I use matlab 2011 64-bit Is there a way to resolve the problem?

thanks

[Friedrich]

This is an out of memory error in the excel side. You need to read a smaller range. For your overall purpose I would suggest writing your own code using EXCEL through COM.

[antonet]

Is there any way to "fix" it within Matlab?

[vcmorini]

News on this post? Having the same issue here!

[John D'Errico]

IF the error is coming from Excel, not from MATLAB, then you cannot fix it in MATLAB. You need to be looking at Excel for this.