When exporting a report as an excel file, the process completes without error on a Windows XP worksation with Office 2007 installed. The same process fails on a Windows 7 Workstation with Office 2010 installed.
The following error is returned:
The file is corrupt and cannot be opened.
To fix –
Open Excel 2010.
Click on File > Options.
Select Trust Center > Trust center settings.
Select Protected view.
Uncheck all the options under Protected View > OK.
Restart Excel 2010 and try to open Report via Excel.