View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
cphalen cphalen is offline
external usenet poster
 
Posts: 9
Default How large can a file get before it is too big for Excel to han

Thanks for the response. I just tried to open the spreadshet on my PC and
the Downloading spreadsheet.xls process starts and Excel is taking up 0-2%
of the CPU and on average 16,660K of memory or less. When the downloading
process is complete and Excel starts to open the file the CPU usage stays
about the same but the memory usage shoots to approximaltey 2G and the error
I listed below appears. The only way to close excel at this point is to end
task. At the time I tried to open this file I was running 3 instances of
Internet Explorer and 1 instanace of Outook.


"FSt1" wrote:

hi
technically file size is limited to available resources meaning disk size,
memory, other and you seem to have hit that some way or another. i would
check task manager to see how much memory excel is using as well as the file
plus how applications you have open and how much junk you have running in
the background. may be a time for upgrade.

regards
FSt1

"cphalen" wrote:

Is there a point when an Excel file can get too large for Excel to handle.
We have users that are opening large excel files and they are getting the
following error:

Excel cannot complete this task with available resources. Choose less data
or close other applications.

The file that we are having the most issues with is 409,774 KB.

Thanks in advance for any response you can provide.