Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

How fix the Excel isssue: Excel cannot complete this task with available resources?

excel

This topic has been archived. This means that you cannot reply to this topic.
1 reply to this topic

#1 JohnHud7

JohnHud7

    CC Lurker

  • Just Joined
  • Pip
  • 1 posts

Posted 31 August 2015 - 02:43 AM

Our acconting Department uses Excel extensively.  They continue to receive this error with slightly complicated Excel sheets: Excel cannot complete this task with available resources.  Choose less dataor close other applications.
 
I have read all of the MS Answer forums, there are some fixes for some people, but not for all.  Does anyone know how to make this disapear forever?


#2 WingedPanther73

WingedPanther73

    A spammer's worst nightmare

  • Moderator
  • 17757 posts

Posted 31 August 2015 - 05:22 AM

You are giving us almost no information to work with, here.

 

What is the hardware on your computers? Processor and RAM, in particular.

 

You say "slightly complicated" Excel sheets. What does that mean? How many cells have formulas? What kinds of formulas? Are there any Macros involved? If you disable macros, does the problem go away?


Programming is a branch of mathematics.
My CodeCall Blog | My Personal Blog

My MineCraft server site: http://banishedwings.enjin.com/





Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download