Corrupt Excel Attachment on Catalog Items

[Nic Omaha]

Im having a strange problem. We have a xlsm excel workbook that users attach to a catalog request item. When you download and open the attachment excel will not open it giving you the following error, however if they email the workbook it opens fine. Any idea why this would get corrupted by ServiceNow?

[Prateek kumar]

Why is the file extension xslx.xlsm?

and see if there is an xlsm extension in system properties>security.

[Nic Omaha]

Sorry didn't catch that. The file isn't I was just making a screen shot. 

[Sumanth16]

Hi , 

Can you check what are the values present in following screenshot:

system properties  --> glide.attachment.extensions

 value in that property.

For example , if that property blank it will allow all type of attachments .

If you declare any file types like xls,xlsx,doc,docx,pdf , system will allow 

only those type of attachments into system.

system properties---> glide.security.file.mime.type.validation property.

If the value is false in that property, it will allow all  MIME type of attachments into system.

Please mark it as helpful (or) correct , if it resolved your issue.

Thanks,

Sumanth

[Sumanth16]

Hi Nicholas,

Can you export data into xls format instead xlsm.Try this method

 Go to UI Context Menu -> Excel (.xlsx) -> Set 'active' to false then save

and then create system property wit the name  'glide.legacy.excel.export' and set it to value of 'true'.

Now try and export using Excel. This will now be producing working Excel sheets.

Thanks,

Sumanth