+ Reply to Thread
Results 1 to 11 of 11

Excel 2007 crash: Just open the file, do anything to it, save, close, open againg = CRASH

  1. #1
    Forum Contributor
    Join Date
    07-15-2016
    Location
    Maputo, Mozambique
    MS-Off Ver
    2007
    Posts
    108

    Angry Excel 2007 crash: Just open the file, do anything to it, save, close, open againg = CRASH

    I mean, anything at all, from formatting, or protect/unprotect, or click on a name to see the userform with the data... ANYTHING!
    I have to save a copy every time i wish to open the file!
    Sometimes even if i put on fullscreen and back, than save, the next time I open it excel will crash when i click on a name.
    I already copied all to notepad and create a new book... exported the forms (2) and reimported. At this point i cannot assign a macro to the buttons over A1 otherwise when i open the file again and click a name it will crash.

    Attached the seek file....

    I am getting crazy over it. It was almost complete....

    The attached file works without crash. Click on a name to see... then do something, save it, open again, click on a name and.... crash!
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,416

    Re: Excel 2007 crash: Just open the file, do anything to it, save, close, open againg = C

    I take it you have no working back-up files? If not, that really is too bad, but hopefully you won't put all your eggs in one basket in future.

    I will see if I can open your file without any crashes.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    07-15-2016
    Location
    Maputo, Mozambique
    MS-Off Ver
    2007
    Posts
    108

    Re: Excel 2007 crash: Just open the file, do anything to it, save, close, open againg = C

    Hi Miss AliGW I surely have a good working copy... but the good one if i do anithing and save is gone! The problem started few hours ago. Until then was ok!

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,416

    Re: Excel 2007 crash: Just open the file, do anything to it, save, close, open againg = C

    The attached seems to be working fine here on Excel 2016 (365). You will see that I have used the user form to delete a record.

    EDIT: Yes, you are right - it crashes when I reopen it. You will need to revert to an earlier copy and rebuild bit by bit until you find what it is that is causing the problem.
    Attached Files Attached Files
    Last edited by AliGW; 03-26-2018 at 12:31 PM.

  5. #5
    Forum Contributor
    Join Date
    07-15-2016
    Location
    Maputo, Mozambique
    MS-Off Ver
    2007
    Posts
    108

    Re: Excel 2007 crash: Just open the file, do anything to it, save, close, open againg = C

    I think it is the EDITFORM that is corrupted. I just made a new one and until now seems to work...

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,416

    Re: Excel 2007 crash: Just open the file, do anything to it, save, close, open againg = C

    Good. Please make a habit of creating INCREMENTAL copies of important files: for examle, you could add a version number to the file each time you open it before working on it using the Save As ... option. I tend to use the date as part of my version numbers.

  7. #7
    Forum Contributor
    Join Date
    07-15-2016
    Location
    Maputo, Mozambique
    MS-Off Ver
    2007
    Posts
    108

    Re: Excel 2007 crash: Just open the file, do anything to it, save, close, open againg = C

    Will do for sure! Thanks for the try and the tip!

  8. #8
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Excel 2007 crash: Just open the file, do anything to it, save, close, open againg = C

    By the way, your INSERTFORM has several compile errors in it, which probably are not helping.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  9. #9
    Forum Contributor
    Join Date
    07-15-2016
    Location
    Maputo, Mozambique
    MS-Off Ver
    2007
    Posts
    108

    Re: Excel 2007 crash: Just open the file, do anything to it, save, close, open againg = C

    Please elaborate a bit... since yesterday I changed stuff... look at the code now...

    Please Login or Register  to view this content.
    It works fine... don't know what to say...


  10. #10
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Excel 2007 crash: Just open the file, do anything to it, save, close, open againg = C

    What's to say- you've changed it since the version that didn't compile.

  11. #11
    Forum Contributor
    Join Date
    07-15-2016
    Location
    Maputo, Mozambique
    MS-Off Ver
    2007
    Posts
    108

    Re: Excel 2007 crash: Just open the file, do anything to it, save, close, open againg = C

    Thank you for the warning anyway!

+ 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. Replies: 2
    Last Post: 05-29-2017, 10:23 AM
  2. Corrupt files> workbooks.open> excel crash
    By ayush002 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-27-2016, 03:00 PM
  3. Excel 2007 takes to open, close and save
    By justme1052 in forum Excel General
    Replies: 6
    Last Post: 05-21-2015, 11:34 AM
  4. custom save and close sub causing other workbooks to crash
    By Jaron_t in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2012, 05:56 PM
  5. Replies: 7
    Last Post: 04-15-2006, 04:20 PM
  6. [SOLVED] Crash attempting to open Excel Add-in using .dll file comprised of VB6 code
    By Sirhc M in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-26-2005, 07:05 PM
  7. [SOLVED] Path\File name length problem Excel Crash on save as
    By Datasort in forum Excel General
    Replies: 0
    Last Post: 04-08-2005, 01:06 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