Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 11-16-2012, 02:40 PM
YounesB3 YounesB3 is offline Excel cannot complete this task with available resources. Choose less data or close Windows XP Excel cannot complete this task with available resources. Choose less data or close Office 2010 32bit
Advanced Beginner
Excel cannot complete this task with available resources. Choose less data or close
 
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel cannot complete this task with available resources. Choose less data or close Task Indicator - All predecessors complete true/false, y/n jdove78 Project 2 10-10-2012 05:53 PM
Excel cannot complete this task with available resources. Choose less data or close excel cannot complete this task with available resources - vlookup Taisho Excel 4 01-27-2012 03:09 AM
Excel cannot complete this task with available resources. Choose less data or close How to set task to be done by 4 resources each one after another? lukusm Project 1 01-16-2012 07:21 AM
Close outlook via task manager scfisher Outlook 0 12-28-2011 07:28 AM
Stop the % Complete of subatasks from counting against the Main task bzeyger Project 0 06-08-2010 06:19 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:33 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft