Excel 2016 Hangs when Filter On / OFF

[Nitesh Khot]

Hi Experts..,

I have Installed Excel 2016 (32 Bit) on my windows 8.1 system.....Whenever I work on small data i.e around 10 cols and 500 rows....My Excel gets Hangs and then i have only options to close workbook.....(If you press ctrl + s then excel save data but not working)...

I have checked any updates but no update found.....is there any source to stop this issue..

Thanks in advance..

Nikh

 

[Chihiro]

I'd first try repair of installation from Control Panel-> Programs & Features.

If that doesn't fix, do a clean install.

Another thing you can check is if there's any unwanted formatting present outside of data range. Check used range by hitting Ctrl + End. This can sometimes cause excessive resource use.

 

[Nitesh Khot]

I have reinstalled / repaired Office but same problem....even i have checked any updates from MS......also checked ctrl + end....but same problem.....is there another issue ...

 

[Chihiro]

Try some of steps in the link.
https://support.microsoft.com/en-ca/kb/2735548

Also, you'd probably have better luck posting in in the forum in link below or contact MS support tech directly.
https://support.office.com/en-ca