very large datasets

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
 
F

Frank Kabel

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
 
N

Norman Harker

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top