+ Reply to Thread
Results 1 to 8 of 8

Unalterable Excel 2016 spreadsheet always crashes

  1. #1
    Forum Contributor
    Join Date
    08-06-2012
    Location
    Brighton, UK
    MS-Off Ver
    MS Office 2021 and 2019
    Posts
    112

    Unalterable Excel 2016 spreadsheet always crashes

    An spreadsheet I've worked with for over 10 years is now oddly unusable.

    I can load it. Everything is there. But if I try to do anything with it - even copying a single cell, delete a cell or row, or checking for errors - it crashes.

    I've disabled KuTools, but that made no difference.

    I've 'repaired' MS Office, but this made no difference.

    I've run a maintenance program (System Mechanic); no difference.

    I would appreciate any tips as to how I can do any repair or fix.

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Unalterable Excel 2016 spreadsheet always crashes

    Are you able to edit it on another computer?

  3. #3
    Forum Contributor
    Join Date
    08-06-2012
    Location
    Brighton, UK
    MS-Off Ver
    MS Office 2021 and 2019
    Posts
    112

    Re: Unalterable Excel 2016 spreadsheet always crashes

    Excellent suggestion.

    Alas, I'm travelling just now so cannot easily do so. The only other person I know with a computer doesn't use Excel 2016.

    But when I get home in 10 days, I'll try that if I've not found a way before then. However, it may not work, so I'd still appreciate any other suggestion.

  4. #4
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Unalterable Excel 2016 spreadsheet always crashes

    Going back to a last known working version (if you have one).

  5. #5
    Forum Contributor
    Join Date
    08-06-2012
    Location
    Brighton, UK
    MS-Off Ver
    MS Office 2021 and 2019
    Posts
    112

    Re: Unalterable Excel 2016 spreadsheet always crashes

    Thanks. I do have one, going back three days; so not a total disaster. But, as I usually do, I made that before I did a set of major changes to the spreadsheet - took hours.

    So altho' I'll survive, I had hoped - perhaps unrealistically - that there may be something I could try that could get me able to use the now compromised version.

  6. #6
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Unalterable Excel 2016 spreadsheet always crashes

    Quote Originally Posted by Zarathrustra View Post
    I've worked with for over 10 years
    I assume this is xlsx format of file so try to open with OR(2007, 2010, 2013, 2016) - if you didn't use specific function(s) for higher then 2007 only it should work if it is possible.
    But first create copy of the file and all exerecises do with copy.

    Another way:
    • Zip and unzip and try open again
      or
    • If there is no sensitive information - attach this file here
      or
    • Create brand new workbook then copy everything to the new file (copy/paste)
      or
    • Create copy via right click on every tab and copy to new, the same, file
    Last edited by sandy666; 02-13-2018 at 01:24 AM.

  7. #7
    Forum Contributor
    Join Date
    08-06-2012
    Location
    Brighton, UK
    MS-Off Ver
    MS Office 2021 and 2019
    Posts
    112

    Re: Unalterable Excel 2016 spreadsheet always crashes

    Thanks you. Your ideas have led me to get at least part of the way.

    My file is xlsm.

    I did copy the file. It did open, with macros disabled (I don't think this had happened before); I made changes and saved them. They have stuck. So perhaps this is going to work.

    Great relief. Much appreciated.

  8. #8
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Unalterable Excel 2016 spreadsheet always crashes

    You are welcome.

    If that takes care of your original question, & to say Thanks, please click on Add Reputtion (bottom left corner of the post of the person(s) who helped you)
    then select Thread Tools from the menu (top right corner of your thread) and mark this thread as SOLVED.
    If you did it already - ignore it.
    Thank you.

+ 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: 1
    Last Post: 09-18-2017, 08:27 AM
  2. excel 2016 stops running(crashes) after running VBA that was working fine on previous vers
    By lauriejerome in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2017, 01:51 PM
  3. [SOLVED] Excel 2016: enable macros on spreadsheet startup
    By Napoleon Dynamite in forum Excel General
    Replies: 3
    Last Post: 03-25-2017, 07:46 PM
  4. Replies: 1
    Last Post: 10-11-2016, 02:13 PM
  5. Replies: 2
    Last Post: 05-24-2016, 10:43 PM
  6. Replies: 0
    Last Post: 12-26-2015, 12:38 PM
  7. After saving the spreadsheet and then running the macro, Excel crashes
    By hydronicengr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-26-2012, 08:03 PM

Tags for this Thread

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