Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 171
Default "Available Resources"?

I guess I'm in full flower of the "For Dummies" mode. I have a WB that is
"only" 70MB or so. I have a Gig of RAM. When I open the WB, and then try to
open another that is, perhaps, 5 MB, or I try to copy some WS from the big
guy to a new Book, I get the "Available Resources" message. There is nothing
out there for me to close, I just want to open the smaller one to verify that
all the rows from it are part of the big guy.

Now, even knowing the WB Save strategy being to copy the whole shebang and
then delete the original, 70MB should only require 140MB, and even allowing
for OS consumption, I should have about 800 MB free. While I guess I would
like to know what's going on here, what I really need to know is how to make
the session behave so that I can have both files open at once!
--
Dave
Temping with Staffmark
in Rock Hill, SC
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,117
Default "Available Resources"?

try:
http://groups.google.com/group/micro...99f5ceda4b1227

and/or:
http://support.microsoft.com/kb/313275/en-us

don't know if will help!
:)
susan



On Jul 5, 10:40 am, Dave Birley
wrote:
I guess I'm in full flower of the "For Dummies" mode. I have a WB that is
"only" 70MB or so. I have a Gig of RAM. When I open the WB, and then try to
open another that is, perhaps, 5 MB, or I try to copy some WS from the big
guy to a new Book, I get the "Available Resources" message. There is nothing
out there for me to close, I just want to open the smaller one to verify that
all the rows from it are part of the big guy.

Now, even knowing the WB Save strategy being to copy the whole shebang and
then delete the original, 70MB should only require 140MB, and even allowing
for OS consumption, I should have about 800 MB free. While I guess I would
like to know what's going on here, what I really need to know is how to make
the session behave so that I can have both files open at once!
--
Dave
Temping with Staffmark
in Rock Hill, SC



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,953
Default "Available Resources"?

http://www.decisionmodels.com/memlimits.htm

--
Regards.
Tom Ogilvy


"Dave Birley" wrote:

I guess I'm in full flower of the "For Dummies" mode. I have a WB that is
"only" 70MB or so. I have a Gig of RAM. When I open the WB, and then try to
open another that is, perhaps, 5 MB, or I try to copy some WS from the big
guy to a new Book, I get the "Available Resources" message. There is nothing
out there for me to close, I just want to open the smaller one to verify that
all the rows from it are part of the big guy.

Now, even knowing the WB Save strategy being to copy the whole shebang and
then delete the original, 70MB should only require 140MB, and even allowing
for OS consumption, I should have about 800 MB free. While I guess I would
like to know what's going on here, what I really need to know is how to make
the session behave so that I can have both files open at once!
--
Dave
Temping with Staffmark
in Rock Hill, SC

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 171
Default "Available Resources"?

Thanks Tom. Now all I have to do is get the tech support dude in bangalesh to
upsize my Swapfile <g!
--
Dave
Temping with Staffmark
in Rock Hill, SC


"Tom Ogilvy" wrote:

http://www.decisionmodels.com/memlimits.htm

--
Regards.
Tom Ogilvy


"Dave Birley" wrote:

I guess I'm in full flower of the "For Dummies" mode. I have a WB that is
"only" 70MB or so. I have a Gig of RAM. When I open the WB, and then try to
open another that is, perhaps, 5 MB, or I try to copy some WS from the big
guy to a new Book, I get the "Available Resources" message. There is nothing
out there for me to close, I just want to open the smaller one to verify that
all the rows from it are part of the big guy.

Now, even knowing the WB Save strategy being to copy the whole shebang and
then delete the original, 70MB should only require 140MB, and even allowing
for OS consumption, I should have about 800 MB free. While I guess I would
like to know what's going on here, what I really need to know is how to make
the session behave so that I can have both files open at once!
--
Dave
Temping with Staffmark
in Rock Hill, SC

Reply
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" Ian Grega Excel Discussion (Misc queries) 2 May 21st 08 12:24 AM
"Not enough system resources to display completely" message johney Excel Discussion (Misc queries) 1 May 9th 07 10:44 PM
Excel "Available Resources" Error - Repost With More Info MDW Excel Programming 0 August 31st 06 02:07 PM
"Excel cannot complete this task with available resources" MDW Excel Programming 4 August 29th 06 04:13 PM
Error message "Not enough system resources to display completely." MKode Excel Discussion (Misc queries) 1 March 2nd 06 12:00 PM


All times are GMT +1. The time now is 08:09 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"