Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,559
    Thanks
    139
    Thanked 12 Times in 12 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,982
    Thanks
    157
    Thanked 774 Times in 706 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
  •