C
chauncystjohn
I have a very large excel file (63mb) that I can't open. Everytime I
try it thinks for a while and then spits out the error "Not Enough
Memory." Now the file is ugly, using many external links, vlookups,
etc. One sheet is about 8000 rows by 40 columns with many of those
columns being fairly complex formulas involving a dozen other columns.
Now I know what you're thinking, what the heck is he using Excel for
something this complicated? But it's grown beyond what I expected it
to be and I don't have time (right now) to move it into any other
program.
That aside, many people claim that the only limitation on file size is
your computer memory. As far as I can tell that assertion is false.
I'm using Windows XP Pro on a laptop with 768MB in RAM. It can handle
30-40MB files without a problem. I even watch my memory performance
while trying to open the file and I have plenty of memory left. When I
got this error I moved it to an XP workstation wtih 3GB of RAM and had
the same problem. To me, that says that Excel or Windows XP limits
that amount of memory that Excel can use for a file. Is this true? Is
there someway around this?
Help!
CStJ
try it thinks for a while and then spits out the error "Not Enough
Memory." Now the file is ugly, using many external links, vlookups,
etc. One sheet is about 8000 rows by 40 columns with many of those
columns being fairly complex formulas involving a dozen other columns.
Now I know what you're thinking, what the heck is he using Excel for
something this complicated? But it's grown beyond what I expected it
to be and I don't have time (right now) to move it into any other
program.
That aside, many people claim that the only limitation on file size is
your computer memory. As far as I can tell that assertion is false.
I'm using Windows XP Pro on a laptop with 768MB in RAM. It can handle
30-40MB files without a problem. I even watch my memory performance
while trying to open the file and I have plenty of memory left. When I
got this error I moved it to an XP workstation wtih 3GB of RAM and had
the same problem. To me, that says that Excel or Windows XP limits
that amount of memory that Excel can use for a file. Is this true? Is
there someway around this?
Help!
CStJ