how to handle error "excel can not complete this task with availble resources. choose less data or close other applications"

[anvrdk]

 I am using LabVIEW 8.5. I am accessing the excel application in a loop. In each iteration i am opening excel reference doing some operations and closing the complete excel reference.

After executing some iterations i am getting the error "excel can not complete this task with available resources. choose less data or close other applications".

please help me to resolve this problem.


<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><meta name="ProgId" content="Word.Document"><meta name="Generator" content="Microsoft Word 11"><meta name="Originator" content="Microsoft Word 11">

[MikeS81]

Hi anvrdk,

why do you open and close excel all the time? It should be enough to open it ones before the loop and close it after the loop. Can you explain what you make there?

Mike

[anvrdk]

I tried the method as you told by opening the excel workbook reference and declared it as global and accessed this reference at different instances in the application and closed all the references at the end of application. But i getting the synchronization problem and it is giving the following error.

[MikeS81]

Hi anvrdk,

can you explain what you want, please? Why do you use a global? How many places do you have, from where you want to work with excel. Now i thinkt you got the first error, because you tried to open one file from two vi´s at the same time.

Mike

[anvrdk]

Thank you for your reply mike.

I need to read the cell values of different work sheets of the same work book within different VIs of the application which reads excel values continuously in a loop.

And I used the semaphore to avoid synchronization

[MikeS81]

Hi anvrdk,

why can´t your read the data all at ones and ditribute it in portions to the sub vi´s? If it´s not possible, then i would anyhow prefere to open excel only ones. Why do you read the data continuously? Did it change while the vi is running?

Mike

[smercurio_fc]

I also have no idea why you're using globals and semaphores. You should be open the Excel file in one place, and passing the references through the VIs using controls/indicators. Have you looked at the examples that ship with LabVIEW? How about the ones in the Excel board?