+ Reply to Thread
Results 1 to 8 of 8

Excel 2013 crashes on opening specific *.xls or*.xlsm file

  1. #1
    Registered User
    Join Date
    08-02-2012
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    11

    Excel 2013 crashes on opening specific *.xls or*.xlsm file

    I have a *.xls with a bunch VBA macros I maintain in Excel 2007. The file has a rich history and I have started it in Excel 2003. Work and save of the file in Excel 2007 and 2010 is working without any problem. There is also code on the sheets.

    In Excel 2013 it is possible to open the *.xls file. It is also possible to save the file without error message. But if you open the file saved with Excel 2013. Excel crashes immediately.

    If the file is corrupt there is no help:
    - If I open the file in safe mode, it also crashes. I even crashes, if there is no code executed on opening the file. It seems the presence of the code causes an issue.
    - If I save in 2013 the file in xlsm format, it shows the same behavior.
    - I have disabled the Autorun macro

    But if you open the corrupt file in Excel while pressing the shift key (disable macro execution), it opens.

    Is there a way to prevent the crash?
    Is is a known 2013 issue?

    I would be happy to provide the file via PM.

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Excel 2013 crashes on opening specific *.xls or*.xlsm file

    Hold Shift key while opening the file. Because holding shift will stop open events.

    Check it and confirm


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Registered User
    Join Date
    08-02-2012
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Excel 2013 crashes on opening specific *.xls or*.xlsm file

    Hi Sixthsense,

    yes, this helps. The file can be opened.

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Excel 2013 crashes on opening specific *.xls or*.xlsm file

    Quote Originally Posted by JochenS View Post
    yes, this helps. The file can be opened.
    Glad and thanks for the feedback

  5. #5
    Registered User
    Join Date
    08-02-2012
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Excel 2013 crashes on opening specific *.xls or*.xlsm file

    ..but the macros are not working and are essential for this workbook..

  6. #6
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Excel 2013 crashes on opening specific *.xls or*.xlsm file

    Quote Originally Posted by JochenS View Post
    ..but the macros are not working and are essential for this workbook..
    Because Holding Shift will disable the macros.

    I strongly believe there should be some bug in your code like changing the cell data without turning off the events which may result in continuous looping which results excel to close that file without any other options

  7. #7
    Registered User
    Join Date
    08-02-2012
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    11

    Re: Excel 2013 crashes on opening specific *.xls or*.xlsm file

    OK, but 2010 open quite fast. I even don't have the chance to enable the macros in 2013. I suppose it is something more generic. Not the execution of code, but presence of code.

    I don't have experience in 2013. What about references or API calls? Is there a difference between 2010 and 2013?

  8. #8
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: Excel 2013 crashes on opening specific *.xls or*.xlsm file

    Quote Originally Posted by JochenS View Post
    I don't have experience in 2013. What about references or API calls? Is there a difference between 2010 and 2013?
    Like you, me too don't know anything about 2013 since I don't have 2013

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel 2007 : Opening an xlsm file
    By doubleudee in forum Excel General
    Replies: 0
    Last Post: 02-09-2011, 10:31 AM
  2. excel 2007 crashes when saving a specific file
    By dvb_24 in forum Excel General
    Replies: 8
    Last Post: 08-04-2009, 07:53 AM
  3. Excel 2007 : Excel 2007 crashes opening an .xls file
    By jkluka in forum Excel General
    Replies: 1
    Last Post: 07-28-2009, 04:59 AM
  4. Replies: 0
    Last Post: 05-17-2006, 12:25 PM
  5. Replies: 0
    Last Post: 12-30-2005, 05:10 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1