Asked by Ara
on 11 Apr 2013

Hi Everyone,

Could you please help me how to overcome this error?

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

Error in ==> xlsread at 325 rawData = DataRange.Value;

Thanks!

*No products are associated with this question.*

Answer by Nick Haddad
on 3 Oct 2014

This issue is a known bug in MATLAB and has been addressed in the following bug report:

The bug report has a workaround which you can install for MATLAB R2013a through R2014b.

Opportunities for recent engineering grads.

## 9 Comments

## Friedrich (view profile)

Direct link to this comment:http://www.mathworks.com/matlabcentral/answers/71591#comment_142567

Sounds like an out of memory either on the excel side or in the amount of data which is allowed to be transfered through COM. How big is the excel file you try to read? What is the range you want to read(so A1 to??)?

## Ara (view profile)

Direct link to this comment:http://www.mathworks.com/matlabcentral/answers/71591#comment_142568

Matlab supposed to plot a map for two stations during five months (5 months per each station). Each day contain an excel file is about 5.85MB, A1-AB1 and each column is about 13354.

## Friedrich (view profile)

Direct link to this comment:http://www.mathworks.com/matlabcentral/answers/71591#comment_142572

At least that size works for me. Can you try this:

What extension does your excel file have? What happens when you try to read a smaller range?

## Jan Simon (view profile)

Direct link to this comment:http://www.mathworks.com/matlabcentral/answers/71591#comment_142575

@Ara: Please post the command, which causes the problem.

## Ara (view profile)

Direct link to this comment:http://www.mathworks.com/matlabcentral/answers/71591#comment_142578

Sorry, if my explanation wasn't clear enough. It means I have to change all of the excel like the code you sent? If yes, I should have said the each excel file is different in terms of size and row but the column are equal(all have 28 column).

@Jan: It seems Matlab could not able to read the other excels anymore. This is that you want me to post??

## the cyclist (view profile)

Direct link to this comment:http://www.mathworks.com/matlabcentral/answers/71591#comment_142580

@Ara, I think Friedrich just wants you to try those two lines of code. That code will create an Excel file which is the same size as yours, and then try to read it back again. He wants to see if that works.

## Ara (view profile)

Direct link to this comment:http://www.mathworks.com/matlabcentral/answers/71591#comment_142581

Thanks to explain me. I tried and those lines gave me an empty excel file but still Matlab can not run to read the rest of the operations and again give me the above error.

## Jan Simon (view profile)

Direct link to this comment:http://www.mathworks.com/matlabcentral/answers/71591#comment_142596

@Ara: No, I asked for the line of code you use to call XLSWRITE. But the posted error message is revealing, that there is a problem with the Excel server. Which Excel version do you have installed?

## Ara (view profile)

Direct link to this comment:http://www.mathworks.com/matlabcentral/answers/71591#comment_142616

@Jan: I did not call XLSWRITE in my code and I think this is the main problem that Matlab shows "not enough storage". I guess I have to write a new function and then call the other process, right? Btw, the Excel 2010 I am using.

@ Friedrich: It's ok to process all the data for 4 months but when exactly it start to read files from the fifth month then the error display.

Please let me know your suggestions?