I have a relatively small file used for work. It contains 20 worksheets (most have very little information, or none at all, which all work fine except for one of them. It WAS working fine, but now every time I try to add or delete a row (which I have to do often) Excel 'encounters an error and needs to close' when I try to save. I have tried copy/pasting the worksheet to a new workbook under a new name, I have tried deleting large chunks of it. I am no where near the information limit in terms of rows and columns. This document stops at Column I and Row 4500. There are no Vlookup links to other pages or other workbooks. It is very simple, and the only 'special features' or functions I am using are the SUM function and freeze panes on the first two rows. I need to be able to work on this file AND save it. Jun 14, 2018 - No worries, here will tutor you to fix if Microsoft Excel for macOS 10.14. Microsoft Excel 2016 Crack Download for Mac is the new Excel. I did everything you wrote but with no positive result. Everytime I open each Office Mac app it crashes after not even a minute. I even tried to re-install from zero OS X Yosemite but nothing changed, they keep crashing. Also, I am using Excel 97. Software/Hardware used: Excel 97, Windows XP (32 bit). I would recommend copying the worksheet tabs to a new workbook. Save it under a different name and see if the problem continues. If it does, then try to do one tab at a time and isolate which sheet is causing the problem. =========== Your MS Office application particularly MS Excel has probably encountered corrupted files or data. This corruption could have many reasons and the best thing you can do is to reinstall your copy of MS Office software and try using MS Excel again and see if it would work. I would recommend copying the worksheet tabs to a new workbook. Save it under a different name and see if the problem continues. If it does, then try to do one tab at a time and isolate which sheet is causing the problem. =========== Your MS Office application particularly MS Excel has probably encountered corrupted files or data. This corruption could have many reasons and the best thing you can do is to reinstall your copy of MS Office software and try using MS Excel again and see if it would work. Please enter an answer. Send me notifications when members answer or reply to this question. @ Labnuke99: Thank you, but I have tried copy/pasting in small chunks and large chunks. The problem continues. I do know which worksheet tab it is, though. I just need a way to debug it. If it helps, the only formula I use on that sheet is the Auto SUM button on the toolbar (meaning I don't actually type it out.) A current formula is =SUM(A29:A35) Then if I insert three rows at A31, it normally updates the sum and range to include the new rows. However, it broke all of a sudden. Is it possible that too many inserts into the SUM range will break it? That seems to be the only thing that doesn't work. I can enter data normally and it will save just fine. The problem only arises when I insert (or delete) a row or column. Thanks -ATCPurdue. Your Excel related problem intrigued me – I tried many different ways but can not break the system. The Auto Sum works very nicely and this option has been from many earlier versions of Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
March 2019
Categories |