View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ian Grega Ian Grega is offline
external usenet poster
 
Posts: 39
Default "Excel cannot complete this task with available resources"

Occasionaly I ask Excel to bite off more than my PC can chew with a lot of
calculations on some large complex spreadsheets.

Is this a software or hardware limitation? Would multiple processors give an
improved performance, a workstation?, supercomputer?, more memory? or does
Excel have limitations?

I also find that to speed up calculations I have to save files and
periodically close Excel, which seems to clear memory allocated to whatever,
is there a way to achieve the same result by not closing Excel?

Appreciate any response,
Thanks - Ian Grega