Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,424
    Thanks
    126
    Thanked 5 Times in 5 Posts

    Excel Cannot Complete Task with available resources

    After running a large macro and then if I try to open up another workbook , I get a message Excel Cannot Complete Task with available resources

    It would be appreciated if someone can kindly assist me
    Attached Images Attached Images

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,641
    Thanks
    115
    Thanked 652 Times in 594 Posts
    Howard,

    Is this on your new rig with 12GB RAM? If you code is storing a large amount of array variables, try adding code that clears them out. Also, try reducing the amount of formatting which can be problematic with large spreadsheets.

    HTH.
    Maud

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •