Out of Memory Error in Excel 2008

S

slakraze

I'm working on a spreadsheet that has about 10 sheets, but it's not a huge project. As I am working I get an "Out of memory" pop up window that keep reappearing after I click the "OK" button. This will repeat indefinitely until Excel crashes. I've lost changes when this happens. I'm on a new macBook with 1G of memory. I don't see any known issues for this. I do have an error report - pasted below:

Microsoft Error Reporting log version: 2.0

Error Signature:
Exception: EXC_BAD_ACCESS
Date/Time: 2008-02-13 12:03:36 -0800
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Version: 12.0.0.071130
Crashed Module Name: unknown
Crashed Module Version: unknown
Crashed Module Offset: unknown
Blame Module Name: unknown
Blame Module Version: unknown
Blame Module Offset: unknown
Application LCID: 1033
Extra app info: Reg=en Loc=0x0409

Thread 0 crashed:

# 1 0xffff0937 in ( + 0x00000000)
# 2 0x014bb357 in _MsoMemmove + 0x00000033 (MicrosoftComponentPlugin + 0x00067357)
# 3 0x0085702f in __mh_execute_header + 0x0085602F (Microsoft Excel + 0x0085602f)
# 4 0x008a1adf in __mh_execute_header + 0x008A0ADF (Microsoft Excel + 0x008a0adf)
# 5 0x008a5038 in __mh_execute_header + 0x008A4038 (Microsoft Excel + 0x008a4038)
# 6 0x00866922 in __mh_execute_header + 0x00865922 (Microsoft Excel + 0x00865922)
# 7 0x0018617d in __mh_execute_header + 0x0018517D (Microsoft Excel + 0x0018517d)
# 8 0x00a33a1b in __mh_execute_header + 0x00A32A1B (Microsoft Excel + 0x00a32a1b)
# 9 0x00a33f77 in __mh_execute_header + 0x00A32F77 (Microsoft Excel + 0x00a32f77)
# 10 0x014eea08 in MEventHandler::FRemoveHandler(unsigned long, unsigned long) + 0x000001DE (MicrosoftComponentPlugin + 0x0009aa08)
# 11 0x906ed863 in .objc_class_name_IPMDFontRange + 0x903C4C43 (HIToolbox + 0x00007863)
# 12 0x906ecc9d in .objc_class_name_IPMDFontRange + 0x903C407D (HIToolbox + 0x00006c9d)
# 13 0x906ecb02 in .objc_class_name_IPMDFontRange + 0x903C3EE2 (HIToolbox + 0x00006b02)
# 14 0x9071b81c in .objc_class_name_IPMDFontRange + 0x903F2BFC (HIToolbox + 0x0003581c)
# 15 0x906edc1c in .objc_class_name_IPMDFontRange + 0x903C4FFC (HIToolbox + 0x00007c1c)
# 16 0x906ecc9d in .objc_class_name_IPMDFontRange + 0x903C407D (HIToolbox + 0x00006c9d)
# 17 0x9070908e in .objc_class_name_IPMDFontRange + 0x903E046E (HIToolbox + 0x0002308e)
# 18 0x0153fc05 in _McpFDispatchEventRef + 0x00000073 (MicrosoftComponentPlugin + 0x000ebc05)
# 19 0x01540195 in _McpRunApplicationEventLoop + 0x0000051B (MicrosoftComponentPlugin + 0x000ec195)
# 20 0x0148fa51 in _McpAlertAppModalRalco + 0x0000005F (MicrosoftComponentPlugin + 0x0003ba51)
# 21 0x008aa17b in __mh_execute_header + 0x008A917B (Microsoft Excel + 0x008a917b)
# 22 0x00668255 in __mh_execute_header + 0x00667255 (Microsoft Excel + 0x00667255)
# 23 0x00847f0a in __mh_execute_header + 0x00846F0A (Microsoft Excel + 0x00846f0a)
# 24 0x005e4c40 in __mh_execute_header + 0x005E3C40 (Microsoft Excel + 0x005e3c40)
# 25 0x005e64d7 in __mh_execute_header + 0x005E54D7 (Microsoft Excel + 0x005e54d7)
# 26 0x007f3e8d in __mh_execute_header + 0x007F2E8D (Microsoft Excel + 0x007f2e8d)
# 27 0x01f8dc94 in _OleSetCustomPutScrap + 0x0000038E (MicrosoftOLE + 0x00045c94)
# 28 0x90936e60 in .objc_class_name_IPMDFontRange + 0x9060E240 (HIToolbox + 0x00250e60)
# 29 0x952912d2 in _gSerializeBufferKey + 0x9523D17A (HIServices + 0x0003e2d2)
# 30 0x952623f4 in _gSerializeBufferKey + 0x9520E29C (HIServices + 0x0000f3f4)
# 31 0x95262336 in _gSerializeBufferKey + 0x9520E1DE (HIServices + 0x0000f336)
# 32 0x932eec99 in .objc_class_name___NSCFSet + 0x931A4D59 (CoreFoundation + 0x00042c99)
# 33 0x90936f8b in .objc_class_name_IPMDFontRange + 0x9060E36B (HIToolbox + 0x00250f8b)
# 34 0x01f7981d in _OleProcessClipboardAE + 0x00000223 (MicrosoftOLE + 0x0003181d)
# 35 0x01f79872 in _OleFlushClipboard + 0x00000050 (MicrosoftOLE + 0x00031872)
#
 
J

james.wilson77

This happens to me without fail on every spreadsheet - "Out of memory"
on a MacBook Pro 2GB. As an example, one spreadsheet has 2 work
sheets with 3 columns each. And only 50 rows. Its an IP register, no
formula...

Sigh. It also frequently crashes when copying a cell to another sheet.
 
A

Alan124

I'm working on a spreadsheet that has about 10 sheets, but it's not a hugeproject. As I am working I get an "Out of memory" pop up window that keep reappearing after I click the "OK" button. This will repeat indefinitely until Excel crashes. I've lost changes when this happens. I'm on a new macBook with 1G of memory. I don't see any known issues for this. I do have an error report - pasted below:

Microsoft Error Reporting log version: 2.0

Error Signature:
Exception: EXC_BAD_ACCESS
Date/Time: 2008-02-13 12:03:36 -0800
Application Name: Microsoft Excel
Application Bundle ID: com.microsoft.Excel
Application Signature: XCEL
Application Version: 12.0.0.071130
Crashed Module Name: unknown
Crashed Module Version: unknown
Crashed Module Offset: unknown
Blame Module Name: unknown
Blame Module Version: unknown
Blame Module Offset: unknown
Application LCID: 1033
Extra app info: Reg=en Loc=0x0409

Thread 0 crashed:

# 1 0xffff0937 in ( + 0x00000000)
# 2 0x014bb357 in _MsoMemmove + 0x00000033 (MicrosoftComponentPlugin + 0x00067357)
# 3 0x0085702f in __mh_execute_header + 0x0085602F (Microsoft Excel + 0x0085602f)
# 4 0x008a1adf in __mh_execute_header + 0x008A0ADF (Microsoft Excel + 0x008a0adf)
# 5 0x008a5038 in __mh_execute_header + 0x008A4038 (Microsoft Excel + 0x008a4038)
# 6 0x00866922 in __mh_execute_header + 0x00865922 (Microsoft Excel + 0x00865922)
# 7 0x0018617d in __mh_execute_header + 0x0018517D (Microsoft Excel + 0x0018517d)
# 8 0x00a33a1b in __mh_execute_header + 0x00A32A1B (Microsoft Excel + 0x00a32a1b)
# 9 0x00a33f77 in __mh_execute_header + 0x00A32F77 (Microsoft Excel + 0x00a32f77)
# 10 0x014eea08 in MEventHandler::FRemoveHandler(unsigned long, unsigned long) + 0x000001DE (MicrosoftComponentPlugin + 0x0009aa08)
# 11 0x906ed863 in .objc_class_name_IPMDFontRange + 0x903C4C43 (HIToolbox + 0x00007863)
# 12 0x906ecc9d in .objc_class_name_IPMDFontRange + 0x903C407D (HIToolbox + 0x00006c9d)
# 13 0x906ecb02 in .objc_class_name_IPMDFontRange + 0x903C3EE2 (HIToolbox + 0x00006b02)
# 14 0x9071b81c in .objc_class_name_IPMDFontRange + 0x903F2BFC (HIToolbox + 0x0003581c)
# 15 0x906edc1c in .objc_class_name_IPMDFontRange + 0x903C4FFC (HIToolbox + 0x00007c1c)
# 16 0x906ecc9d in .objc_class_name_IPMDFontRange + 0x903C407D (HIToolbox + 0x00006c9d)
# 17 0x9070908e in .objc_class_name_IPMDFontRange + 0x903E046E (HIToolbox + 0x0002308e)
# 18 0x0153fc05 in _McpFDispatchEventRef + 0x00000073 (MicrosoftComponentPlugin + 0x000ebc05)
# 19 0x01540195 in _McpRunApplicationEventLoop + 0x0000051B (MicrosoftComponentPlugin + 0x000ec195)
# 20 0x0148fa51 in _McpAlertAppModalRalco + 0x0000005F (MicrosoftComponentPlugin + 0x0003ba51)
# 21 0x008aa17b in __mh_execute_header + 0x008A917B (Microsoft Excel + 0x008a917b)
# 22 0x00668255 in __mh_execute_header + 0x00667255 (Microsoft Excel + 0x00667255)
# 23 0x00847f0a in __mh_execute_header + 0x00846F0A (Microsoft Excel + 0x00846f0a)
# 24 0x005e4c40 in __mh_execute_header + 0x005E3C40 (Microsoft Excel + 0x005e3c40)
# 25 0x005e64d7 in __mh_execute_header + 0x005E54D7 (Microsoft Excel + 0x005e54d7)
# 26 0x007f3e8d in __mh_execute_header + 0x007F2E8D (Microsoft Excel + 0x007f2e8d)
# 27 0x01f8dc94 in _OleSetCustomPutScrap + 0x0000038E (MicrosoftOLE + 0x00045c94)
# 28 0x90936e60 in .objc_class_name_IPMDFontRange + 0x9060E240 (HIToolbox + 0x00250e60)
# 29 0x952912d2 in _gSerializeBufferKey + 0x9523D17A (HIServices + 0x0003e2d2)
# 30 0x952623f4 in _gSerializeBufferKey + 0x9520E29C (HIServices + 0x0000f3f4)
# 31 0x95262336 in _gSerializeBufferKey + 0x9520E1DE (HIServices + 0x0000f336)
# 32 0x932eec99 in .objc_class_name___NSCFSet + 0x931A4D59 (CoreFoundation+ 0x00042c99)
# 33 0x90936f8b in .objc_class_name_IPMDFontRange + 0x9060E36B (HIToolbox + 0x00250f8b)
# 34 0x01f7981d in _OleProcessClipboardAE + 0x00000223 (MicrosoftOLE + 0x0003181d)
# 35 0x01f79872 in _OleFlushClipboard + 0x00000050 (MicrosoftOLE + 0x00031872)
#

Hi,

Maybe the excel file is corrupt. I think you can try a popular Excel
file recovery tool called Advanced Excel Repair to repair your Excel
file. It is a powerful tool to repair corrupt or damaged Excel files.

Detailed information about Advanced Excel Repair can be found at
http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Hope this will help.

Alan
 
P

Paulina Oliva

I also got an out of memory message the first day I used it. It also has crashed on me.
 
E

Eric Nienaber

I have just recently switched from PC to Mac (the new MacBook Pro) I purchased Office 2008 but am also experiencing this out of memory problem and not always with the same file. This typically happens when trying to create a pivot table.

I have also noticed (looking at istat) that when using Excel the memory usage goes up to 1.5 gig of the 2 I have on the machine. This happens with spreadsheets created in this version and with very little data. Switching to other applications then obviously also generate an out of memory error. This then results in the machine just hanging.

Any advice?
 
M

Michael Lee

I am also having this problem regularly with a new (i.e. wiped disk clean) install of Leopard and Office 2008. Occurs most frequently when I am attempting to copy a range of cells. I am using very small sheets (three sheets, only about 20 rows, 10 columns) with very little calculation.

On one occurrence, after pressing the OK button on the 'Not enough memory' error message, Excel actually created a new workbook that was a copy of the sheet that had focus. Very weird, and indicative of a big problem in the code, IMHO. I may have to install my old Windows version of Office 2003 on my Boot Camp partition if this isn't fixed soon...
 
P

Pat McMillan

For those of you seeing this:

1) Have you installed the 12.0.1 update?
2) Would you be able to send me a system profile?
3) If you have a specific file that you always encounter this with, would it
be possible to send that file to me?

(e-mail address removed)

Thanks,

Pat
 
A

aleding67

Pat, I have sent details via e-mail as requested. Rgds Eric

Hello folks - any update on this? i am also seeing this on pretty
much every file and it occurs about once every 30 minutes. I am also
running 12.0.1 but this was occurring in 12.0.0 as well. Let me know
if you need any information from my machine.

Thanks.
 
P

Pat McMillan

We've been working to get a consistent repro case for this, but are having a
hard time. Every report seems to be a little bit different. Eric sent me a
file, but on a MBP with almost the same specs as his, I don't see the
problem.

It would help a lot if you could a) send me any file that encounters this
problem consistently ([email protected]), b) send me a system profile,
c) tell me exactly what steps usually lead to the Out of Memory alert? Is it
when creating pivot tables as it was for Eric, copying a range of cells as
someone else reported? Or is it something different?

Thanks for your help. I hope we can get to the bottom of this.

Pat
 
B

bgarceau

I encountered this error this morning. I too am using Excel 2007 for Mac on a MacBook Pro with the latest/up-to-date OS. I was creating an Excel spreadsheet with three worksheets. The main worksheet contains a list of text problem descriptions from a trouble ticketing system. the second worksheet contains a list of concatenated column contents from the third worksheet.

I was (painstakingly) working my way through the list of text problem descriptions and assigning a category from a pull-down list of problem categories (contained in a column on one of the other worksheets).

I had completed just over 200 of them when the Out of Memory error occurred. I let the app die and restart. I allowed Excel to send the exception info off to Microsoft.

When I attempted to continue after Excel restarted I noticed that the values from the pull-down list are still in place for each item that I assigned a category from the pull-down list, but they are only text now - no data validation list in the cell anymore.

Man. This is no fun at all. The whole point of the pull-down list was for efficiency, which has just now gone out the window!

Pat, I will send you the document that I was working on when this occurred. If you have any way to fix it (it must be corrupted somehow) I'd sure appreciate it.
 
B

bgarceau

I am happy to report that Time Machine has saved my little project. I was able to recover the file from two hours ago and I can now continue.

Pat, please let me know if you need the un-corrupted version of this file for comparison purposes.
 
P

Pat McMillan

Thanks and sorry for the delay. Actually, yes, it would be very helpful to
have a copy of the file before it became corrupted. Please go ahead and send
directly to me: (e-mail address removed).

Thanks,

Pat
 
E

esakshaug

Just a quick note on this from me. I'm working on an Excel spreadsheet
originally made on a PC. The out of memory thing happens after just a
few minutes of working with the file when I use the Save-command. I'm
also working up against a PC-server, So this might be a mac-to-pc
issue.
Let me know if you need any more info, cause this is getting on my
nerves. I have to restart Excel about 50 times every day now.

Erlend Sakshaug
@The Student Planner
 
T

Tristen Lin

Just a quick note on this from me. I'm working on an Excel spreadsheet
originally made on a PC. The out of memory thing happens after just a
few minutes of working with the file when I use the Save-command. I'm
also working up against a PC-server, So this might be a mac-to-pc
issue.
Let me know if you need any more info, cause this is getting on my
nerves. I have to restart Excel about 50 times every day now.

Erlend Sakshaug
@The Student Planner

I have same problem. Any PC EXCEL file work for a wile then Out of memory shows to me. Especially after a lot of copy&paste
 
E

esakshaug

I have same problem. Any PC EXCEL file work for a wile then Out of memory shows to me. Especially after a lot of copy&paste

Copying, pasting, changing colors and saving... major pain.
 
P

Pat McMillan

Thanks a lot for letting us know! There have been several different
incarnations of a bug resulting in Out of Memory alerts and we targeted at
least a few of them for this release. It's great to know that we fixed the
scenarios you were hitting! If others still do encounter those alerts after
installing SP1, we absolutely want to hear about it.

Thanks again,

Pat
 
I

IAmAdam

Hi,

Maybe the excel file is corrupt. I think you can try a popular Excel
file recovery tool called Advanced Excel Repair to repair your Excel
file. It is a powerful tool to repair corrupt or damaged Excel files.

Detailed information about Advanced Excel Repair can be found athttp://www..datanumen.com/aer/

And you can also download a free demo version athttp://www.datanumen.com/aer/aer.exe

Hope this will help.

Alan

Alan - please stop recommending your program to people who are having
trouble with excel files on a MAC. You ought to know it won't work,
since you wrote it yourself.
 
T

tototam

Thanks a lot for letting us know! There have been several different
incarnations of a bug resulting in Out of Memory alerts and we targeted at
least a few of them for this release. It's great to know that we fixed the
scenarios you were hitting! If others still do encounter those alerts after
installing SP1, we absolutely want to hear about it.

Thanks again,

Pat




--
Pat McMillan
Macintosh Business Unit
Microsoft Corp.
This posting is provided ©øAS IS©÷ with no warranties, and confersno rights.- ëßíúù¬ìÚéÄÙþí® -

- úéãÆù¬ìÚéÄÙþí® -

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top