Hello,

We have next problem with Excel 2013:
When I try to edit cell containing number in .xlsm file with macros, Excel window starts displaying "(Not responding)" in its title. CPU consumption at that time is 25% according to Task Manager. After such freeze of ~1 minute it starts to work as usual, until I try to edit other cell.

I tried to disable all Add-ins and edit the file, but got same result.

Also, on PC with Excel 2007 the file opens long time but editing goes without such freezes.

Could you please tip what may be wrong and how I can fix the problem above?

Hello again,

My colleague helped me with the problem, below is the solution:

In Excel 2013 go to File >>> Settings >>> Advanced tab >>> Clear 'Automatically Flash Fill'
At General tab >>> Clear 'Show Quick Analysis options on selection'

• Marked as answer by Kirill Skudarnov 21 hours 19 minutes ago

Hello again,

My colleague helped me with the problem, below is the solution:

In Excel 2013 go to File >>> Settings >>> Advanced tab >>> Clear 'Automatically Flash Fill'
At General tab >>> Clear 'Show Quick Analysis options on selection'

• Marked as answer by Kirill Skudarnov Thursday, May 14, 2015 10:12 AM

Hello again,

My colleague helped me with the problem, below is the solution:

In Excel 2013 go to File >>> Settings >>> Advanced tab >>> Clear 'Automatically Flash Fill'
At General tab >>> Clear 'Show Quick Analysis options on selection'

• Marked as answer by Kirill Skudarnov Thursday, May 14, 2015 10:12 AM

Hi,

Thanks for visiting our forum and sharing your experience here. It'll be benefited to our communicator.

Have a good time.

Regards,

George Zhao
TechNet Community Support