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.
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.
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
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.
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.
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
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?
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
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!
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?
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?
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?
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.
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?
+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.
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!
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.
You're still helping us in 2021. Thanks alot
Really worthy video...... Thanks a lot. This reduced my every day head ache.
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.
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
P
Excellent tip. I just tried it and works great. Thank you so much!!!
watching it in SEPT 2021.
thanks for the amazing tip
My hero of the day !!!! thank you
This is good, but what's the downside? Why not store all Excel files as .xlsb and not as .xlxs?
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.
Bingo! You are awesome, Sir.
Awesome tricks ..... thanks a lot
Real help for my 200 MB+ xlsx spreadsheets
Ur the man Sir , u made my day thank you , your video helped me alot
Thanks for this video! Does XLSB improve calculation speed?
Dude, you freaking ROCK!
thanks for this! will this mess up any margins or formats in a document?
Thanks in a million. That was brilliant.
I tried this, and it worked... Thanks a lot!
Glad to hear. Thanks for taking the time to watch. You've made me smile :)
Airen Nyakundi tqyuros💨
I had 27.2mb file,used your idea, though it has reduced to 23.1mb but still taking long to open and save
Thanks it was really helpful
sorry, I see that you have answered this already. Indeed we can save macro enbale files in Xlsb format. Thanks
thank you sir, it's very useful to me .great !
Thank you for sharing this!! :)
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.
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
You save my life man!
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?
Thanks! Great tip. Wow!
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
Is XLSB same as 'Excel Binary Workbook' for previous excel versions?
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!
will this affect the formulas you have incorporated in the excel file? i'm not talking about the macros
any update ?
can i use the same method to reduce a 'macro enabled file'?
awsome 😃👍
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?
did you find the solution yet ?
Use powerquery
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?
Thanks for your help ♥ ♥ ♥
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?
Wow! Thats Great! :-)
Thanks Man!
Dude you rock
Does it work xlsm ->xlsb? I have a huge 290 MB XLSM file and it crashes when I start any macro :( will this help?
Is there any disadvantage of xlsb file?
thank you for your tricks but still i am facing SLOW Excel, Any other method to make Faster than .XLSB??
yeah, buy an ssd for 20$ problem solved
Hello sir,
If sheet contains vba project. It will work?
how to change .xlsx file into .xlsb without opening the file. I have a 40MB file. I cannot imagine ever opening it.
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.
split the datasets into more excel workbooks to call when needed and set calculation mode to manual when opening if you can
Seems like my 15 MB spreadhsheet with Pivot tables saves with 18.6 MB with XLSB.
Not working for me !
What about links? Do we have to reroute the links?
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?
Thank you
what will i do my excel file take a long time to save
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?
You might have saved me
Tnx Bro .
Is there really no downside to this at all?
+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.
Thanks for the info!
I tried this, mine increased in size for some reason by 200mb
mine increased from 33k kb to 40k kb huhu
Your authority is not recognised in Fort "My-Mom-Said-So".
thank you
Hi Sir
When I filter my data, it takes few minutes to come back to from filtration.
Can you please help me?
and if it contains micro?
subscribe for your channel