Results 1 to 10 of 10
  1. #1
    Star Lounger
    Join Date
    Feb 2002
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Corrupt Excel file? Memory error. (2000)

    I worked on a spreadsheet on my laptop for almost 5 hours this morning. After having another cup of coffee I attempted to open the file and keep getting the following error:

    DDE Server Window: EXCEL.EXE - Application Error
    The instruction at "0x30075f02" referenced memory at "0x04510ab0". The memory
    could not be "written".

    I copied it to diskette and have been unable to open it on other PC's, with the same error, so it appears that the file became corrupt. I would really prefer not to have to start over with this -- is there any way to open this file so I can get at least some of the information?

    Thanks for any tips -

    Randy
    Attached Files Attached Files

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    Location
    New York, New York, Lebanon
    Posts
    1,449
    Thanks
    1
    Thanked 1 Time in 1 Post

    Re: Corrupt Excel file? Memory error. (2000)

    <img src=/S/hello.gif border=0 alt=hello width=25 height=29> Randy

    Can you recreate the workbook again?

    Do you have a backup copy?

    Can you clean up the workbook? Do you need help doing this?

    How many fonts and colors do you have?

    You know Excel workbooks are very susceptible to damage.

    Good luck.

    Wassim
    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupt Excel file? Memory error. (2000)

    If there are any macros in the workbook, try opening the workbook without executing any auto macros. Open Excel and then Use File Open to navigate to the file. Select the file and hold down the Shift key when you press Open.
    Legare Coleman

  4. #4
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupt Excel file? Memory error. (2000)

    Randy, some things that have worked for me, although they may or may not apply in your case:

    1. Delete all files and folders in the WindowsTemp directory (use at your own risk in case some apps are using these-never has been a problem for me however)

    2. Try the Detect and Repair option under Help

    3. Try saving as an HTML file (although you might lose some formatting I believe)

    4. Search for files with extensions .xlb and delete or rename them (this has cured most of my problems since my favorite thing to do is create custom toolbars and manipulate the user interface).

  5. #5
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,055
    Thanks
    2
    Thanked 417 Times in 346 Posts

    Re: Corrupt Excel file? Memory error. (2000)

    If none of the other posts about how you might be able to open the workbook resolves the problem, you may be able to get the information out of it by linking to it from another workbook. If, for example, your corrupt file is C:My Documentsfilename.xls, which has workings on Sheet1, open a new workbook and insert the formula:
    ='C:My Documents[filename.xls]Sheet1'!A1
    If all goes well, you'll now have whatever was in cell A1 on Sheet1 of the corrupt workbook. If Excel accepts this, copying the formula across and down to cover the used range in the corrupt worksheet. This will give you the values (though not the underlying formulae or formatting) for all cells on the that worksheet. Change the Sheet1 reference to match whatever other worksheets your corrupt workbook has and you'll get the equivalent results for them too.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  6. #6
    Star Lounger
    Join Date
    Feb 2002
    Posts
    74
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupt Excel file? Memory error. (2000)

    MACROPOD - Thanks! That's one thing that I didn't think of, which worked perfectly. I was able to retreive everything but one Sheet, which must be what was causing the problem. I'll remember this for future reference.

    Thanks to everyone else who replied to this post too.

    Randy

  7. #7
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupt Excel file? Memory error. (2000)

    On one occasion, I was able to recover a corrupt Excel file by opeing it in IE.
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  8. #8
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Dallas plus 20 miles or so, Texas, USA
    Posts
    876
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupt Excel file? Memory error. (2000)

    Jan, have you tried the new StarOffice yet?

  9. #9
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupt Excel file? Memory error. (2000)

    Nope. I have a space problem on my drive. Besides that I'm glad my system runs stably as it is now....

    I just got this advice from the MS NG and copied it in.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  10. #10
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Corrupt Excel file? Memory error. (2000)

    A few tips:

    Options to try and open a corrupt file

    - Set calculation to manual
    - open the file, but disable macros (assuming you've set macro security to medium: Tools, Macro, security)
    - As soon as you've clicked the disable macros button, press control-pageup or control-pagedown, thus changing sheets.

    If that does not work, try creating a link to the file:

    ='c:my documents[MyFileName.xls]Sheet1'!A1

    and copy right and down. This at least gets you the worksheets values.

    Sometimes the Excel viewer (or Word) enables you to open the file and copy information out of it.

    Also, Excel XP can sometimes repair XL files with trouble.

    Lastly: Download the office suite from www dot sun dot com slash staroffice (awkward spelling to hopefully avoid another autodeletion of posting...) it's a killer app for file recovery.

    And one more:

    Download my Autosafe.zip from http://www.bmsltd.ie/mvp

    Edited Mar 13th 2004 to update link
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •