Make Large Excel Files Smaller and Open Faster with .XLSB

[@jra901225able]

dude, this just reduced the size of my file from 87MB to 71MB but the loading/opening file was reduced totally, like from wasting 5 ~ 10 minutes (no kidding) to open it, now it just took 35 seconds to open it. IT'S FANTASTIC! Thank you so muh mate. great video.

[@josepedroalmeida6586]

Just to say thank you, this really works. I had a 2GB file that took 25minutes to open. It now opens in less than 5min!

[@asankaw1]

thank you for opening my eyes.. i was blind for a minute and have totally forgotten how to save in under another format.. geeze.. my grey cells were blocked by rust and dust collected over the time of unused period...thank you

[@shao-hsingweng7740]

P

[@at-excel]

I use XLSB very often. My Standard rate of compression is round about 60-70% of the original size. But it is much faster when opening like seen in your tutorial.

[@antony6444]

You're still helping us in 2021. Thanks alot

[@cakemartyr5794]

This is good, but what's the downside? Why not store all Excel files as .xlsb and not as .xlxs?

[@AnanthRaj123]

Really worthy video...... Thanks a lot. This reduced my every day head ache.

[@Darkmage426]

Great tip. Definitely going to have to start using this at work. However, would you know a way of being able to save a file to the new format without having to open first? We have a company wide report that saves as an html file that we open in Excel to run information and getting it to open is a pain. If I could figure out how to open it each morning and re-save it under this format it would save an hours work each morning.

[@cuejorge2003]

Excellent tip. I just tried it and works great. Thank you so much!!!

[@fancypants2007]

Is there *any* advantage to using .XLSX vs .XLSB, or should we always use .XLSB? It seems like .XLSB would be the default if there are no disadvantages.

[@indranilrakshit8990]

That's the trick, one would think that xlsb has only advantages over xlsm files but truth is since xlsm stores the data in xml format while xlsb stores it in binary, so you'd have better chances at recovering the workbook in case it ever gets corrupted

[@JustforFun-zg9cw]

watching it in SEPT 2021. thanks for the amazing tip

[@cmejia4401]

thanks for this! will this mess up any margins or formats in a document?

[@dineshjayakody5283]

My hero of the day !!!! thank you

[@AamirMahboubKhan]

Bingo! You are awesome, Sir.

[@martinargimon730]

can i use the same method to reduce a 'macro enabled file'?

[@baharuddin7841]

Awesome tricks ..... thanks a lot

[@Nilgard]

Thanks for this video! Does XLSB improve calculation speed?

[@angellachica]

will this affect the formulas you have incorporated in the excel file? i'm not talking about the macros

[@21CANCEL]

any update ?

[@richellsarong2890]

It really helps sir..i can open my excel file faster than the other but I still can sned it through email. Before I save it throght Binary the size was 160MB but when i saved it to binary its 104MB already. The only problem is that still I cant send it through email.. can you help me?

[@lromeroyt]

Is XLSB same as 'Excel Binary Workbook' for previous excel versions?

[@hudsonrobert3307]

I had 27.2mb file,used your idea, though it has reduced to 23.1mb but still taking long to open and save

[@leocadiomachado]

Ur the man Sir , u made my day thank you , your video helped me alot

[@martinargimon730]

sorry, I see that you have answered this already. Indeed we can save macro enbale files in Xlsb format. Thanks

[@bb86ify]

I tried this, and it worked... Thanks a lot!

[@alphanaturalresourcesittra5657]

Glad to hear. Thanks for taking the time to watch. You've made me smile :)

[@jamalmukisa893]

Airen Nyakundi tqyuros💨

[@Derfflinga]

Real help for my 200 MB+ xlsx spreadsheets

[@WindTechInsights]

if it still does not help (like you cannot open), you still can use it by opening an empty table and referring by formulas to the large one...you can have access to the data you need

[@tonyalexander4822]

Dude, you freaking ROCK!

[@hx2856]

Is there any disadvantage of xlsb file?

[@davida.taylor8444]

I had 47mb wkbk that increased to 68mb when I saved it as an xlsb. I have 103k rows and 18 columns of data without any formulas. Then I realized that I had 1 pivot chart on a hidden tab which I then deleted. After deleting this tab, my file reduced to 32mb. I'm guessing then, that xlsb doesn''t work nicely with pivot tables and pivot charts?

[@adilsonchrestani]

Great Video! However, I still have a problem : My excel file is about 10GB and it won´t load completely because it exceeds the limit of 1 million lines. How am I able to solve that?

[@IDITAGI]

did you find the solution yet ?

[@bredemeijer9648]

Use powerquery

[@sarahnarcisse1275]

Hey, Would this work for excel files that don't have enough ressources to work? I have data taken from a database that seems to take up to much space. When I try to manipulate my data with pivot tables I get the error excel cannot complete this task because of not enough memory?

[@lotteryplayer]

What about links? Do we have to reroute the links?

[@ValmisFilm]

Does it work xlsm ->xlsb? I have a huge 290 MB XLSM file and it crashes when I start any macro :( will this help?

[@anthonysisay1557]

Thanks in a million. That was brilliant.

[@arettapierson5262]

I had a massive file of ~600GB (yes, and it gets larger every month adding ~330K lines). Making the file be extension .xlsb helped reduce size by more than half (now only 260GB), and it runs ok but still really slow to open, move within, refresh pivots, save, everything is super slow and it still crashes and gives problem messages. Any other guidance would be appreciated.

[@dxfvgyhjh]

split the datasets into more excel workbooks to call when needed and set calculation mode to manual when opening if you can

[@molinpinto4714]

how to change .xlsx file into .xlsb without opening the file. I have a 40MB file. I cannot imagine ever opening it.

[@calvinnicasio5204]

You save my life man!

[@ancanc4110]

Thanks it was really helpful

[@errolm8313]

What if I have an xlsx file that has a bug in it making the file almost impossible to open bc it's too large?

[@amit12724]

what will i do my excel file take a long time to save

[@pemba.sherpa5675]

Thank you for sharing this!! :)

[@manojbirhade]

thank you for your tricks but still i am facing SLOW Excel, Any other method to make Faster than .XLSB??

[@dxfvgyhjh]

yeah, buy an ssd for 20$ problem solved

[@mirzakhudrathullabaig7993]

Hello sir, If sheet contains vba project. It will work?

[@oimnasa]

awsome 😃👍

[@stephaniech.5502]

Wow, this really worked! It reduced a 36.2 MB file to 3.45 MB! Loading time didn't change dramatically, but I had problems mostly with the size. Thanks a lot! Would there be a way to do something like this with a Word file? I have one that makes Word stop responding every time I save it because it's such a long document, everything is laggy with that file. Thanks again!

[@larsknudsen6004]

Seems like my 15 MB spreadhsheet with Pivot tables saves with 18.6 MB with XLSB. Not working for me !

[@sachinkishore4115]

thank you sir, it's very useful to me .great !

[@jameslatrobe-bateman1455]

Thanks! Great tip. Wow!

[@cybertenshi6706]

Weird thing, I cannot resize my excel file on my office laptop, but my colleague managed to resize the same file by 90% on his pc. Does anyone know why resize doesn't work for me?

[@markowenzaragoza1340]

Wow! Thats Great! :-)

[@1Polikina1]

Is there really no downside to this at all?

[@at-excel]

+1Polikina1 Hi, there are some very smal downsides. a) If the structure of the file is corrupt, you can save and inspect pieces of the XML-Files and try to repair the file. You can watch the data after renaming XLSM or XLSX to ZIP. In XLSB you will only see a BIN-file. b) Some 3rd Party Tools expect to get XLSX or XLSM for data exchange. c) my Windows Phone-App cannot open XLSB. But SharePoint, Excel Online, Calc and other tools have no problem with XLSB. d) You cannot see, if there is a Macro in it before opening the file. e) it is not communicated so that many people feel not save when using XLSB. BUT IT IS GREAT! We discussed it with many Excel-Experts and MVPs, the use it, too. But you have to have a look at the target system. Where and in which environment will your file used if the file leaves your control. I use XLSB very often. It's smaller and much faster - like seen in the tutorial.

[@1Polikina1]

Thanks for the info!

[@imranahmed1696]

Dude you rock

[@emokai1976]

Thanks for your help ♥ ♥ ♥

[@saadichayon6562]

Thanks Man!

[@GigglrTv]

Your authority is not recognised in Fort "My-Mom-Said-So".

[@nbp10000]

You might have saved me

[@ammunjecomposites4848]

I tried this, mine increased in size for some reason by 200mb

[@zack94972]

mine increased from 33k kb to 40k kb huhu

[@darwinescobido3184]

Tnx Bro .

[@Hhh.123fff]

Thank you

[@403519315778]

Hi Sir When I filter my data, it takes few minutes to come back to from filtration. Can you please help me?

[@MohammadRayeesAhmad]

and if it contains micro?

[@emokai1976]

subscribe for your channel

[@greekvenom]

thank you