Comments on: Why does Excel keep crashing?http://itknowledgeexchange.techtarget.com/itanswers/why-does-excel-keep-crashing/
Fri, 09 Dec 2016 16:23:18 +0000hourly1By: donethathttp://itknowledgeexchange.techtarget.com/itanswers/why-does-excel-keep-crashing/#comment-98596
Thu, 03 Nov 2011 19:33:07 +0000#comment-98596Glad you fixed the problem. I’ve had that exact problem in Excel 2003. For anyone desperate out there, here are 2 other ways that have worked for me in the past…
1) Open a new workbook, use format painter to copy all column formatss from the bad sheet to a new sheet, then copy all/paste Formula & Values (NOT Formats) to the new sheet. Not sure why this worked but copying the entire sheet to a new workbook did not.
2) Using Open Office, open the file and save in native format, CLOSE Open Office, reopen the program and the file and save in Excel format.
Neither one is bulletproof every time and choice #2 required work when reopened in Excel but was better than recreating from scratch.
Gary
]]>By: atcpurduehttp://itknowledgeexchange.techtarget.com/itanswers/why-does-excel-keep-crashing/#comment-83905
Tue, 16 Nov 2010 15:30:42 +0000#comment-83905@Chippy088 Yes, I convinced our IT department to get me the free conversion addon from Microsoft that allows 97 to read the newer .xlsx files. I can’t save them in that format, but I can at least read them now. I think it actually applies to all Office programs, so Word can read .docx now and PowerPoint 97 can read .pptx.
]]>By: chippy088http://itknowledgeexchange.techtarget.com/itanswers/why-does-excel-keep-crashing/#comment-83899
Tue, 16 Nov 2010 15:06:16 +0000#comment-83899Interesting. You say you are now running a Excel 2007 document file on a Excel 97 machine?
]]>By: frankthetankhttp://itknowledgeexchange.techtarget.com/itanswers/why-does-excel-keep-crashing/#comment-83564
Wed, 10 Nov 2010 18:24:14 +0000#comment-83564Good you got it figured out must of just not saved correctly for some reason.
]]>By: rechilhttp://itknowledgeexchange.techtarget.com/itanswers/why-does-excel-keep-crashing/#comment-83430
Tue, 09 Nov 2010 05:18:48 +0000#comment-83430Is it possible to install again only EXCEL package and uninstall the already installed EXCEL package ! If this possible, u have only to install the very common and necessary components or go for typical installation. Not to install extra components or Add-ins. Try to remove Add-Ins also….
]]>By: atcpurduehttp://itknowledgeexchange.techtarget.com/itanswers/why-does-excel-keep-crashing/#comment-83405
Mon, 08 Nov 2010 17:28:00 +0000#comment-83405I found a solution, sort of. I was able to put the file onto a flash drive and load it into a computer with Microsoft Excel 2007. I resaved it as a 2007 document, then transferred it back to the original computer. It works just fine now. I still do not know what caused the initial problem.
]]>By: frankthetankhttp://itknowledgeexchange.techtarget.com/itanswers/why-does-excel-keep-crashing/#comment-83404
Mon, 08 Nov 2010 17:24:50 +0000#comment-83404Might be something you have to talk to the IT department about starting Excel in safe mode and seeing if you can save the data and links. And i didn’t notice you were using excel 97 that tip was for 2007 sorry lol. The Repair option I think was added in 2003.
]]>By: atcpurduehttp://itknowledgeexchange.techtarget.com/itanswers/why-does-excel-keep-crashing/#comment-83393
Mon, 08 Nov 2010 14:13:53 +0000#comment-83393@ sbelectric: Thank you for your input. I suppose starting over would be the best route, but I want to avoid this problem again. The one worksheet that has the problem contains multiple SUM formulae, and several of them overlap with each other. At last count, there were a total of 422 SUM formulae involved on this one worksheet.

As for the absolute cell values, how would I find that out? I have gone through most of the formula cells and they appear to be correct… although I haven’t looked at them after adding/deleting rows before trying to save. Thank you again for your help, and I will keep you posted on what happens.

]]>By: atcpurduehttp://itknowledgeexchange.techtarget.com/itanswers/why-does-excel-keep-crashing/#comment-83392
Mon, 08 Nov 2010 14:08:50 +0000#comment-83392@ Rechil: This computer is completely clean. Our network IT administrators see to that. Thank you, though. The only problems this computer has is low memory. Still, all other Excel files work just fine. I just broke this one massive worksheet somehow.
]]>By: rechilhttp://itknowledgeexchange.techtarget.com/itanswers/why-does-excel-keep-crashing/#comment-83381
Mon, 08 Nov 2010 08:44:32 +0000#comment-83381It may be OS problem or Virus problems ! Check with good Anti-Virus…..
]]>