very large datasets

  • Thread starter Thread starter pc
  • Start date Start date
P

pc

I have a very large dataset ( 600 MB )that I need to open with excel
2003. Will the system crash if I do this ?

Any suggestions, comments welcome.

thanks
 
Hi
probably you will encounter problems when opening this with Excel:
- one worksheet has a maximum of 65536 rows -> so you may have to split
your dataset on several worksheets
- Depends on the dataset format (text format, Access database, etc.) ->
so you may provide some more details

IMHO Excel seems not to be the right application to open this kind of
large dataset. Have you tried opening this datafile (of course after
making a backup copy). If yes did you receive an error message
 
Hi "pc"

See Frank's reply first!!

But:
Here's a quote from Charles Williams:
http://www.decisionmodels.com/memlimitsc.htm

"Excel 2003 has a substantially increased memory capacity which may be
in excess of 1 gigabyte: I have successfully used over 750MB of
workbook memory on a 768MB RAM Windows XP system."


It may well be possible but that doesn't make it advisable.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top