Out of Memory Error in Excel 2008

[Bob Greenblatt]

My computer is using SP2, but I can't solve the problem yet!
My program have 42 radio button + 48 label
I use lot of copy&praste.
I think the problem is not simple, as the help file descript, VBA have
limit of 64k segment, is it related to the "out of memory" error?

You will have to restate the problem, and your exact configuration of Excel
and operating System. VBA is not supported in Macintosh Excel 2008, which is
the forum where you are posting the question. Also, there is no SP2 for
Macintosh Office, so somehow one of us is chasing the wrong problem.

 

[Joshua]

I was getting the occasional "out of memory" error but it was only after working for at least an hour and sometimes I'd go all day without seeing it. then I installed SP1 and now I'm lucky if I get 15 min before the error comes up, or 20 before it crashes all on it's own.

The file i've been working in is a large file with 10 sheets, lots of references and formula's, and one sheet with a lot of charts. I really started to have problems after I started making charts. At one point I saved the file and all of my charts went blank because they'd lost the cell references and I had to either delete and re-create each chart or edit each chart to repair the cell references, getting error codes about bad cell references each time I made a correction.

Is there a mac compatible version of the repair utility? or am I going to have to redo several days of work because Excel through a hissy fit and corrupted my file?

 

[Pat McMillan]

Hi Joshua,

Is there any chance you can send me your file so I can investigate? If not,
if you get into the crash again, could you click on More Info... In the
Microsoft Error Reporting application, select all, and copy/paste the crash
log to an email message and send to me ([email protected])? I'd love to
figure out what's going on here, but it's going to take some work to get to
the bottom of the problems you're seeing.

Thanks,

Pat

 

[seh2000]

Hi All,

Any update on this Out of Memory Eroor in Excel 2008 for MAC?

I have same error on small and big excel sheets, mainly in excel sheets made
by Excel for Windows.

My configuration is:
Model Name: MacBook Pro 15"
Model Identifier: MacBookPro1,1
Processor Name: Intel Core Duo
Processor Speed: 2.16 GHz
Boot ROM Version: MBP11.0055.B08
SMC Version: 1.2f10
System Version: Mac OS X 10.5.3 (9D34)
Kernel Version: Darwin 9.3.0
Excel Version: 12.1.0 (080409)
Last Modified: 5/15/08 10:32 PM
Kind: Universal

If this help...

Cheers - Steen

Hi Joshua,

Is there any chance you can send me your file so I can investigate? If not,
if you get into the crash again, could you click on More Info... In the
Microsoft Error Reporting application, select all, and copy/paste the crash
log to an email message and send to me ([email protected])? I'd love to
figure out what's going on here, but it's going to take some work to get to
the bottom of the problems you're seeing.

Thanks,

Pat

On 5/27/08 7:04 AM, in article (e-mail address removed)9absDaxw,

I was getting the occasional "out of memory" error but it was only after
working for at least an hour and sometimes I'd go all day without seeing it.

[quoted text clipped - 12 lines]

to redo several days of work because Excel through a hissy fit and corrupted
my file?

 

[seh2000]

Sorry forget to say that the excel files I se the problem in comes in .XLS
format, BUT the got lost of macros in them. If I select just "open" the
problems is there, but if I select "Open and Remove Macros" the problem seams
to dissapear...
Steen

Hi All,

Any update on this Out of Memory Eroor in Excel 2008 for MAC?

I have same error on small and big excel sheets, mainly in excel sheets made
by Excel for Windows.

My configuration is:
Model Name: MacBook Pro 15"
Model Identifier: MacBookPro1,1
Processor Name: Intel Core Duo
Processor Speed: 2.16 GHz
Boot ROM Version: MBP11.0055.B08
SMC Version: 1.2f10
System Version: Mac OS X 10.5.3 (9D34)
Kernel Version: Darwin 9.3.0
Excel Version: 12.1.0 (080409)
Last Modified: 5/15/08 10:32 PM
Kind: Universal

If this help...

Cheers - Steen

Hi Joshua,

[quoted text clipped - 16 lines]

 

[CyberTaz]

Hello Steen -

The error typically doesn't have anything to do with disk space or RAM - it
usually means the program is unable to access information it needs because
that information is not available (out of - as in "not in" - memory). There
really isn't anything to "update" you on though - you've pretty much
answered your own question in your other message

The error in your case is evidently due to the fact that the workbooks
involved are dependent on macros & Office 2008 doesn't support VBA. I'm
afraid it's just that simple - that's why the files open without the error
if you choose the option to remove the macros.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Hi All,

Any update on this Out of Memory Eroor in Excel 2008 for MAC?

I have same error on small and big excel sheets, mainly in excel sheets made
by Excel for Windows.

My configuration is:
Model Name: MacBook Pro 15"
Model Identifier: MacBookPro1,1
Processor Name: Intel Core Duo
Processor Speed: 2.16 GHz
Boot ROM Version: MBP11.0055.B08
SMC Version: 1.2f10
System Version: Mac OS X 10.5.3 (9D34)
Kernel Version: Darwin 9.3.0
Excel Version: 12.1.0 (080409)
Last Modified: 5/15/08 10:32 PM
Kind: Universal

If this help...

Cheers - Steen

Hi Joshua,

Is there any chance you can send me your file so I can investigate? If not,
if you get into the crash again, could you click on More Info... In the
Microsoft Error Reporting application, select all, and copy/paste the crash
log to an email message and send to me ([email protected])? I'd love to
figure out what's going on here, but it's going to take some work to get to
the bottom of the problems you're seeing.

Thanks,

Pat

On 5/27/08 7:04 AM, in article (e-mail address removed)9absDaxw,

I was getting the occasional "out of memory" error but it was only after
working for at least an hour and sometimes I'd go all day without seeing it.

[quoted text clipped - 12 lines]

to redo several days of work because Excel through a hissy fit and corrupted
my file?

 

[seh2000 via MacKB.com]

E'lo CyberTaz,

Understood, however my second message became partial incorrect later (so
sorry for this) as either if I save in .XLS or .XLSX format with our without
the VBA the problem remains (Out of memory) so I believe there is a real
error in Excel 2008 for MAC.
Further I installed OpenOffice 3.0 later in the day and there same Excel
sheet I can open, I can edit the sheet and the sheet can be saved with or
without changes with no problems
BR// Steen

Hello Steen -

The error typically doesn't have anything to do with disk space or RAM - it
usually means the program is unable to access information it needs because
that information is not available (out of - as in "not in" - memory). There
really isn't anything to "update" you on though - you've pretty much
answered your own question in your other message

The error in your case is evidently due to the fact that the workbooks
involved are dependent on macros & Office 2008 doesn't support VBA. I'm
afraid it's just that simple - that's why the files open without the error
if you choose the option to remove the macros.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Hi All,

[quoted text clipped - 40 lines]

 

[Pat McMillan]

These Out of Memory alerts are real issues that we want to get to the bottom
of. We're working on fixes for some of these issues that we've been able to
isolate, but would love help narrowing down additional scenarios.

Steen - if you have any files that reproduce this that you could send my
way, it would be a great help.

Thanks,

Pat McMillan
(e-mail address removed)

E'lo CyberTaz,

Understood, however my second message became partial incorrect later (so
sorry for this) as either if I save in .XLS or .XLSX format with our without
the VBA the problem remains (Out of memory) so I believe there is a real
error in Excel 2008 for MAC.
Further I installed OpenOffice 3.0 later in the day and there same Excel
sheet I can open, I can edit the sheet and the sheet can be saved with or
without changes with no problems
BR// Steen

Hello Steen -

The error typically doesn't have anything to do with disk space or RAM - it
usually means the program is unable to access information it needs because
that information is not available (out of - as in "not in" - memory). There
really isn't anything to "update" you on though - you've pretty much
answered your own question in your other message

The error in your case is evidently due to the fact that the workbooks
involved are dependent on macros & Office 2008 doesn't support VBA. I'm
afraid it's just that simple - that's why the files open without the error
if you choose the option to remove the macros.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Hi All,

[quoted text clipped - 40 lines]

to redo several days of work because Excel through a hissy fit and
corrupted
my file?

 

[liberty ellman]

I get these errors just by opening Excel. I don't even get a chance to open a file. But even trying to open a simple .csv file from the desktop (with 10 rows of text) gives this error. The rest of the office suite is painfully slow as well! HELP! Mac G5 dual 2.0ghz 4gb of ram. I run some huge applications on this. A spreadsheet and a word document should not cause me pain... I'm on the 12.1.1 version.

 

[Fergal Condron]

Hi there,

Is there any way that you can send the file directly to me, this can help us
diagnose the problem and hopefully get a fix for what you are experiencing?
My email is (e-mail address removed)

Thanks!
Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.

 

[mtpaper]

I am having this problem too = Out of Memory
I am working with Excel 2008 v 12.1.1.
I have a mac with lots of memory etc.
The file is not big (3 small worksheets in the workbook)
It was created on a Windows computer.
It doesn't have any macros.
I've been sending error message log to Microsoft as requested, when
I'll copy and paste the error next time

 

[CherylAClements]

I JUST upgraded to Office 2008 this eveninghoping it would be an improvement and am having the same problems with ever file I have opened in Excel. I got a message to open or open without macros and as these files were not originally mine and I do not use the macros, I selected open and remove macros. On saving both files I have been working on, I get the out of memory message and have to hit ok several times as once is not enough. This is not a large file, maybe 40'ish columns and and 150 rows on three sheets.

I would be happy to send this file to any one who needs it because if Excel doesn't work, I will very shortly be unemployed.

 

[Fergal Condron]

Hi Cheryl,

Can you send the file to me directly at (e-mail address removed) and I can take
a look?

Thanks!
Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.