LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
MDW MDW is offline
external usenet poster
 
Posts: 117
Default "Excel cannot complete this task with available resources"

I've got an Excel file that links to two other files, runs some calculations
using VBA, and then creates an output file. Today, I started getting the
message "Excel cannot complete this task with available resources. Choose
less data or close other applications." during my run.

I know this isn't a physical memory issue (and this is borne out by looking
at the Task Manager), and I've read the article on Excel's inherent memory
limits. However, what I'm doing isn't new - I ran the exact same process with
different source files this morning and had no problems. It's worked fine for
months. I'm using the same PC and there've been no software changes (XL2003,
XP Pro).

When I run this process, I have no other Excel instances open.

Any ideas as to what else might be causing the issue? TIA.
--
Hmm...they have the Internet on COMPUTERS now!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel cannot complete this task with available resources PSM[_15_] Excel Worksheet Functions 1 June 12th 09 11:26 PM
Excel cannot complete this task with available resources. Ali Excel Worksheet Functions 2 August 1st 08 07:49 AM
"Excel cannot complete this task with available resources" Ian Grega Excel Discussion (Misc queries) 2 May 21st 08 12:24 AM
"Excel cannot complete this task with available resources" /Torben, Denmark Excel Discussion (Misc queries) 2 May 6th 07 04:19 PM
Excel cannot complete this task with available resources. ChopperChand Excel Discussion (Misc queries) 0 April 20th 06 04:21 PM


All times are GMT +1. The time now is 09:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"