Microsoft Office Forums - View Single Post - Excel cannot complete this task with available resources. Choose less data or close

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

View Single Post

Old

11-16-2012, 02:40 PM

YounesB3

YounesB3 is offline

YounesB3 uses Windows XP

Windows XP YounesB3 uses Office 2010 32bit

YounesB3 uses Office 2010 32bit

Office 2010 32bit

Advanced Beginner

The original poster

Join Date: Jul 2012

Posts: 37

YounesB3 is on a distinguished road

Default

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

Code:

    Workbooks.Open Filename:= _
        "?:\(path to the file)", UpdateLinks:=0

And this at the end:

Code:

    ActiveWorkbook.Save
    ActiveWindow.Close

Kind Regards,
YB3

Reply With Quote