Excel 2010 crashes when macros are enabled

[meera77c]

Hi,

We purchased a copy of MS Excel 2010 and installed and activated it successfully. We have been trying to open an excel (2010 version .xlsm) file which has a lot of macros and embedded vidoes. The file opens correctly but Excel crashes when we click on the 'Enable Content' button to enable the macros in the file. We get an error "Excel encountered a Problem and needs to close".

We are using a system with Windows XP (SP3) as the OS. It satisfies all the hardware requirements for MS Excel 2010. We had re-formatted the system and re-installed the OS on this machine before installing Excel and we do not have any other programs installed, except symantec antivirus. We had also checked for windows updates on this machine after installation (MS Office was updated with 3 patches that were available)

This file was sent to us by our client and it works perfectly on his machine. He has even tried it on a couple of other machines and not faced any problem, we can be sure that there is nothing wrong with the file. Is there any reason why we would be encountering this Issue? Are we missing some libraries or add-ons required to run excel with macro content? Do we have to tweak the default settings in order to overcome this Issue? Any help/guidance will be greatly appreciated as we are at our wits end.

Regards,
Meera

 

[michelsmith]

Hi,

Registry is a database where data contained on the computer such as software installed in the computer, their settings etc. The registry needs to be checked for any errors. Any errors that happen in the registry will affect the Microsoft Excel. Make sure that you clean the registry once in a while. The cleaning of registry could be done by any registry cleaning software.