Excel XLSB files and one drive sync

%3CLINGO-SUB%20id%3D%22lingo-sub-1142429%22%20slang%3D%22en-US%22%3EExcel%20XLSB%20files%20and%20one%20drive%20sync%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1142429%22%20slang%3D%22en-US%22%3E%3CP%3E%3CBR%20%2F%3EHi%2C%3CBR%20%2F%3ESo%20we%20are%20looking%20at%20moving%20a%20department%20who%20heavily%20use%20spreadsheets%20to%20Teams%20%2F%20Sharepoint%20and%20encouraging%20them%20to%20sync%20files%20via%20the%20onedrive%20sync.%3CBR%20%2F%3EThey%20have%20a%20mix%20of%20xlsx%20and%20xlsb.%20For%20the%20large%20excel%20files%20they%20have%20converted%20a%20majority%20of%20these%20from%20xlsx%20to%20xlsb%20(i.e.%20binary%20files)%20to%20reduce%20size%20and%20opening%20times%3CBR%20%2F%3EThe%20files%20can%20range%20from%20anywhere%201%20to%20500mb!%3CBR%20%2F%3EI%20have%20a%20few%20questions%20regarding%20xslbs%2C%20user%20experience%20and%20demand%20on%20the%20network%3C%2FP%3E%3CP%3E1)%20What%20are%20peoples%20experience%20of%20using%20xslb%20files%20in%20a%20sync'd%20environment%20with%20O3656%20Sharepoint%20%2F%20Teams%3CBR%20%2F%3E2)%20As%20i%20understand%20it%20when%20you%20make%20a%20change%20to%20a%20standard%20xlsx%20file%20(or%20any%20ms%20office%20files)%20that%20is%20sync'd%20locally%20it%20would%20just%20send%20back%20that%20part%20of%20the%20file%20you%20changed%20since%20last%20save%20(e.g.as%20a%20small%20xml%20section%2Felement)%20however%20with%20an%20xslb%20does%20it%20send%20the%20entrie%20documnet%20back%3F%20i.e.%201%20change%20to%20a%20100mb%20file%20would%20send%20100mb%20back%3F%3CBR%20%2F%3E3)%20How%20does%20autosave%20work%20with%20xslbs%20again%20does%20it%20try%20and%20send%20the%20full%20file%20size%20back%20on%20save%3F%3C%2FP%3E%3CP%3E4)%20Any%20issues%20with%20co%20-authoring%20and%20xlsbs%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20tried%20to%20find%20some%20actual%20official%20guidance%20on%20this%20so%20if%20anyone%20has%20any%20please%20share.%20Or%20just%20hands%20on%20experience%20%2F%20knowledge.%3CBR%20%2F%3EI%20am%20aware%20of%20large%20excel%20files%20not%20being%20able%20to%20open%20in%20web%20view%2C%20macro%20issues%2C%20linked%20spreadsheets%20my%20questions%20are%20more%20specific%20around%20xslbs!%3C%2FP%3E%3CP%3Ethanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1142429%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFiles%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOneDrive%20for%20Business%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESync%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Contributor


Hi,
So we are looking at moving a department who heavily use spreadsheets to Teams / Sharepoint and encouraging them to sync files via the onedrive sync.
They have a mix of xlsx and xlsb. For the large excel files they have converted a majority of these from xlsx to xlsb (i.e. binary files) to reduce size and opening times
The files can range from anywhere 1 to 500mb!
I have a few questions regarding xslbs, user experience and demand on the network

1) What are peoples experience of using xslb files in a sync'd environment with O3656 Sharepoint / Teams
2) As i understand it when you make a change to a standard xlsx file (or any ms office files) that is sync'd locally it would just send back that part of the file you changed since last save (e.g.as a small xml section/element) however with an xslb does it send the entrie documnet back? i.e. 1 change to a 100mb file would send 100mb back?
3) How does autosave work with xslbs again does it try and send the full file size back on save?

4) Any issues with co -authoring and xlsbs?

 

i tried to find some actual official guidance on this so if anyone has any please share. Or just hands on experience / knowledge.
I am aware of large excel files not being able to open in web view, macro issues, linked spreadsheets my questions are more specific around xslbs!

thanks

0 Replies