Excel cannot complete this task with available resources. Choose less data or close other

[YounesB3]

Hello everyone, I'm having an issue when I try to run a macro (16 different workbooks open):

"Excel cannot complete this task with available resources. Choose less data or closer other applications"

Here's the macro (I replaced the titles of the files for policies issues):

Please Login or Register  to view this content.

What Gives? Seems like a memory problem, but I need these 16 files separated...

N.B.: Cross posted:

http://www.mrexcel.com/forum/excel-q...ml#post3317544

http://www.msofficeforums.com/excel/...html#post42156

[rylo]

Hi

Seems like you are just pasting data from ABCD.xlsm to other workbooks. Why do you need to have them all open at the same time? Just open each one, do the copy / paste, save, shut it down, then open the next one etc.

rylo

[YounesB3]

Hi

Seems like you are just pasting data from ABCD.xlsm to other workbooks. Why do you need to have them all open at the same time? Just open each one, do the copy / paste, save, shut it down, then open the next one etc.

rylo

To save time...?

[YounesB3]

I solved the issue by adding the following at the beginning of each file:

Please Login or Register  to view this content.

And this at the end:

Please Login or Register  to view this content.

Kind Regards,

YB3

[ravi.lele]

Hi YounesB3,

I had the same issue, tried your suggestion and it worked like a charm.
Thanks for sharing this solution.

Keep posting....

[YounesB3]

No problem, glad that it helps out!