At 600 MB you are probably better off using a database than XL. XL is just
not built to handle that size...

Check out this link for info on memory and such...
http://www.decisionmodels.com/index.htm
--
HTH...

Jim Thomlinson


"E-Double" wrote:

We have a user who is trying to import 600MB (yes Megabytes) of data into an
Excel speadsheet. The person said that they got an error message when trying
to do this the first time, but does not remember what the error message
stated. So we tried it again and it apparently is populating the book but
takes hours. Is there a maximum file/data size that one should try and
import/open in Excel? And also, are there any 'tricks' to enhance the
performance of Excel when attempting such a process? TIA ...