Excel 2010 Compatability Mode - Causing Excel to Crash?

[+Byt Subscriber¹]

Hi All,

This is a really strange problem i appear to be having and im at a loss of what to try next... 5 users all have different computers all on Windows 7 and all have Office 2010 fully patched up with the latest updates.

1 user out of the 5 has a problem in Excel 2010 where they open up and old format workbook such as .xls or open office workbook, and after working on it for abit, the ribbon / menu bar at the top will become nu-responsive, you can click to change the font or click the File menu etc etc

Weird thing is you can still save the workbook by doing ctrl+s but you cant use the menu in any way.

Office 2010 is fully patched up, all addon's have been disabled and it still happens.

I have reinstalled Office 2010 but the issue still happens.

Could it be that installing the Microsoft Office Compatibility Pack will help? maybe a Java / Flash issue? Im not sure really tbh with you all.

Any advice, no matter how weird it seems will be so helpful.

Thank You x

[Cosmin]

make sure to adapt firewall rules to update settings for that office pack. Experienced simmilar issues with ACDSee while trying to update but Kaspersky firewall was set to block any try.

[+Byt Subscriber¹]

Thank you for the reply, i am going mental with this!

Funnily enough i did remove AVG Internet Security from the machine, if it turns out that AVG was causing it all along, i am never using that software again.

Could you explain a little more on why the firewall would cause it please?

[Roger H. Veteran]

Moved to Software Discussion & Support

Is it possible to covert the workbook to a XLSX format right away and continue working on it in that format?

[+Byt Subscriber¹]

This is something the user is testing at the moment, if it turns out that they can indeed work OK once converted the Workbook, they dont really want to have to convert upto 500 work books!

[Cosmin]

Funnily enough i did remove AVG Internet Security from the machine, if it turns out that AVG was causing it all along, i am never using that software again.

Could you explain a little more on why the firewall would cause it please?

Thought that excel could possibly try to automatic-save/update (uncheck these from options) on defined interval the worksheet, action that can be refused(ruled) by firewall. Any news after removing AVG?

[S_Herbie]

This is something the user is testing at the moment, if it turns out that they can indeed work OK once converted the Workbook, they dont really want to have to convert upto 500 work books!

Should be pretty quick to convert all of the files using some VBA to loop through and resave them.

I would convert to XLSB rather than XLSX...