Hi all,

We are having some trouble with Microsoft Office files using macros.

The files can be stored either on a File Server or a Client and we are being presented with errors opening and saving macro enabled documents, though they will work flawlessly for a time.

It is also not limited to one machine or one version of Office. When the macro enabled document breaks, it breaks for all machines.

Initially it was thought the macro recording tool was to blame for the errors until we had a developer create a simple macro which later started to present the same problems.

We have tried both safe mode and normal boot. The only way we can stop the errors from happening is to turn off macros through settings, though this allows us to retrieve the data, we still need to have the macros functional.

Any help would be greatly appreciated.

Operating Systems are running Windows 7 x64 and Windows 10 x64.

The event logs show the following;

Faulting application name: EXCEL.EXE, version: 15.0.4815.1000, time stamp: 0x56e7a5d7
Faulting module name: VBE7.DLL, version: 0.0.0.0, time stamp: 0x55a6b6cd
Exception code: 0xc0000005
Fault offset: 0x0000000000091bc1
Faulting process id: 0x1a74
Faulting application start time: 0x01d1a14807063ed2
Faulting application path: C:\Program Files\Microsoft Office 15\Root\Office15\EXCEL.EXE
Faulting module path: C:\Program Files\Common Files\Microsoft Shared\VBA\VBA7.1\VBE7.DLL
Report Id: 57af697d-0d3b-11e6-ad5e-005056c00008
Faulting package full name: %14
Faulting package-relative application ID: %15