We help IT Professionals succeed at work.
Get Started

Excel suddenly crashing when deleting rows or columns

6,964 Views
Last Modified: 2017-04-04
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.
Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 9 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE