troubleshooting Question

Excel suddenly crashing when deleting rows or columns

Avatar of Glen_Sydney
Glen_SydneyFlag for Australia asked on
Windows 10* ParallelsMicrosoft ExcelMicrosoft Office
9 Comments1 Solution6974 ViewsLast Modified:
I’ve suddenly started experiencing a frustrating random problem with Excel 2010, which I run in Windows 10 under Parallels Version 12.1.3 (41532) on an iMac.

Whenever I need to delete columns or delete rows from an Excel spreadsheet, at some unpredictable point part way through the process Excel crashes every time.

After rebooting, the error message always says:

“One or more invalid conditional formats were removed from the workbook”.

In the original file that failed, I’ve gone right through and thinned out and simplified all of the conditional formatting, but to no avail.

I have also spent hours trying to isolate when the problem started occurring, but it is not just on files I have edited recently or after any known event, and can happen on any old file I try.

I tried doing a System Restore only to find that it had been turned off so that was useless.

I did run a repair of Office 2010 but nothing improved.

I have tried running Excel in Safe Mode but the problem still occurs.

This has cost a lot of lost time and unreliability with my work and I am no closer to a solution.

The only thing I did notice is that there seems to have been a major update of Office 2010 and Windows in the last day or two.

Has anyone any advice on how I can fix this please?

Thankyou for your assistance.

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros