Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error Log (Excel 2000/SR3)

    When opening a file, Excel loads the file (I can see it) and then I receive an error message that says Excel.exe has generate errors and will be closed....an error log is being created. I can not figure out why this error is occurring and am wondering where the error log is and whether or not it contains information that can be utilized to debug the file. I've tried opening the file with and without macros enabled, in Excel Safe Mode and reset the registry to no avail. In previous posts with a different problem, many of you recommended I use openoffice.org to open a corrupt file, but doing so deletes certain items in the target file (data validation, named ranges, etc.) so I am hesitant to do that.

    Seem to remember reading somewhere where one can write code in one Excel file to grab sheets from another file (even if the file is closed) and paste on the new worksheet. Am I dreaming? If not, can anyone point me in the right direction?

    Thanks. <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

  2. #2
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Log (Excel 2000/SR3)

    I found something that came from J-Walk.com (tip 82).
    I attached the workbook.
    Hope it helps.

    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Error Log (Excel 2000/SR3)

    You can do a direct reference to a closed sheet and get the VALUES in the cells, though I know of no way to get the formulas, format, named ranges, validations etc from a closed workbook.

    To get the values, open a new workbook and in cell A1 of one of the sheets enter:
    <pre>=IF(ISBLANK('Cath[BAD File.xls]Sheet1'!A1),"<blank>",'cath[BAD File.xls]Sheet1'!A1)</pre>


    replace the path, filename and sheetname as appropriate.

    Copy this to fill all the rows and and all the columns from the worksheet

    select the entire sheet (ctrl-a), copy it (ctrl-c) and edit - pastespecial -values over the region to eliminate the formulas
    edit - replace
    Find what: <blank>
    replace with:
    [note: leave the replace with empty]
    <replace all>
    This will replace all the strings "<blank>" and make the cells actually blank

    repeat this for other worksheets in the corrupt workbook

    Steve

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

    Re: Error Log (Excel 2000/SR3)

    Have you tried with calc set to manual?

    Another thing to try if the file first shows up and then crashes Excel: try pressing control-pageup or pagedown whilst the file is loading.
    I once had a workbook with a corrupt chart on one of the sheets. If I saved the file with that sheet active and then tried to open the file, Excel would crash, unless I performed the trick above. I used a macro to delete the chart and got things back to normal.

    All other methods I know (apart from openoffice) will make you loose much, much more than just named ranges and validation.

    If you like you can send me the file so I can have a go at it (or attach it here if it is not too large)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  5. #5
    New Lounger
    Join Date
    Jun 2003
    Posts
    16
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error Log (Excel 2000/SR3)

    Jan -

    I have tried setting the calc to manual and the page up / page down trick. Neither of those techniques worked. I understand opening corrupt files is a frequent problem and one in which you've provided recommendations on more than one occassion. As a matter of fact, I have your list of possible solutions provided in a previous post within reach right now. I believe that one or more of my embedded controls (command buttons) is/was corrupt, which led to my problem. The spreadsheet had more than 100 embedded controls. What I believe was happening was the file was loading but Excel was choking when trying to "draw" the corrupted control. In other words, it appears that as Excel is displaying the file, it provides the text first and then displays the controls. Maybe I'm grasping at straws, but what led me to this conclusion was that I had a huge number of *.emf files on my hard drive in a temp folder from each aborted load attempt. When I highlighted a *.emft file in Explorer and looked at the preview, I could see a preview of the embedded control. I was not aware of the existence of *.emf files. In any case, I could delete a majority, but not all of these files. The fact that I could not delete some of them indicated to me that there was some corruption in them.

    Any way, sorry to be so long winded, but I deleted all non-essential buttons (and consolidated others into a master button) and resaved. It appears to have solved the problem. I can still send you the original file, if you would like to see for yourself, but hesitate to post it publicly here.

    Oh, and I had a friend try to open the file in XL2002 and it offerred to repair the problem and opened the file. However, when I reviewed the repair report, it indicated that corruption was so extensive, that the code and some controls were deleted. Essentially, it deleted ALL of my VBA code. Not the solution I was looking for, but another hint at the source of the problem.

    Thank you very much for your consideration of this issue and your previous posts regarding opening corrupt files.

    Sincerely,
    Joe

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

    Re: Error Log (Excel 2000/SR3)

    I strongly suspect that you *can* delete all emf files after a reboot. That just might fix the entire problem.
    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
  •