When exporting Reports in Excel 2007 (XLSX) format, users who have the "Always Available Offline" option enabled on the network folder where they are exporting to may intermittently experience the following error:
Error opening export: Error opening Microsoft Office 2007 Application: External table is not in the expected format. Make sure you have Microsoft Office 2007 installed on your machine.
To resolve this issue, disable the "Always Available Offline" option on the network folder where the exports are being saved.
Steps to disable 'Always Available Offline':
Navigate to the folder where the exports are being saved to.
Right click on the folder and uncheck "Always Available Offline".
The Raiser's Edge 7.93.5782 ; The Financial Edge 7.85.52, patch 1