I upgraded from Office 2010 to 2013 a couple of months back, and I find Excel 2013 the most frustrating piece of software I have every worked with. I have a spreadsheet just under 6 MB that used to work flawlessly in 2010. Now it constantly freezes, takes forever when I copy something into a cell (and this could be as simple as a name or email address — I won’t even try to go into copying a row that has formulae or trying to add/delete a row above/below it), takes forever to save (or it doesn’t and crashes). There’s not a day that goes by where I receive the message that Excel is not responding, shuts down, and tries to repair something. I share it with a few co-workers weekly and now they too are experiencing the same slowness, crashing, etc.
Any thoughts on what could be causing this? I have read somewhere that antivirus software may be an issue, but why now with 2013 and not with 2010? I use Avira and I’m surely not going to turn it off for Excel 2013. Yesterday I read something about COM Addin’s causing this — so I removed the only one that was there. This didn’t make any difference. Any help would be appreciated. I’m at my wits end and am wondering if there is an alternative to Excel out there somewhere. I would upload it to Google but uploading deletes all the formula. Thanks for listening.