Custom Content Type - File Formats - XLSB supported?

Hello, I recently set up custom content types for my standard templates so that everybody (in subsites) can benefit from it using the NEW button. So far so good, all documents open, I only have ...

Document Library

files

David Eberhardt

Copper Contributor

Nov 13, 2018

After opening a Ticket with Microsoft regarding XLSB, I have the following news:

- XLSB files do seem to open fine now (don't know how the error message vanished...)

- XLSB files, when opened and then saved are switched to XLSM (which is uncomfortable, especially if I want to all users to use XLSB by default (update pending on this one still).

David Eberhardt

Copper Contributor

Nov 16, 2018

Another update:

The Error Message is back for XLSB.

Opening the Document from the Document library works fine, but opening it as a Template document via the NEW button will result in Excel wanting to open the document as a HTM file.

No changes to the Trust Center, IE trusted Sites settings or Excel Save options have yielded a different behaviour.

At this point I am fairly certain that the Bug lies with SharePoint adding something at the End of the Document which breaks Excels identification of the File Type (and proper handling thereof)

The file I specified in the Custom Site Content was "/VT/Templates/XLSB.xlsb"

It is briefly visible in the Splash Screen of Excel that something is attached to the end (but cut off):

"/VT/Templates/XLSB.xlsb?..."

I do not know what it is, but it is messing with the file type.

Forum Discussion

Custom Content Type - File Formats - XLSB supported?