PROBLEM


Please update the Excel config for the above home. Error recorded is:

 

03/12/2015 10:49:59 - PAVILION-ADMIN/PavilionCourt.Admin - Error 1429 has occurred at line 1349 in EXPORTTOEXCEL

Module - STAFFROSTER,ON... ,EDITSTAFFDETAILS,EDITSTAFFINFO.CMDSTANDARD1.CLICK,EXPORTSTAFFDETAILSTOEXCEL,EXPORTTOEXCEL,ON... ,ERRHAND,

Code Line - SELECT StaffDetails

 

Error message - OLE IDispatch exception code 0 from Microsoft Excel: You are attempting to open a file type that is blocked by your File Block settings in the Trust Center...

 


SOLUTION


Change the settings in Excel to allow imported data from Jarman, as it is was blocked by the File Block Settings.


FILE > OPTIONS > TRUST CENTER > SETTINGS > FILE BLOCK SETTINGS > UNTICK BOXES > DONE