I did this as described but once I want to select the word file it is somehow greyed out and I cannot select it to be used for powerpoint. Any idea?

Thank U So Much I Appreciate You So Understandable

how to convert excel file upto 16 kb

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

Wow! thank you for this amazing video instriuction.

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

You're still helping us in 2021. Thanks alot

watching it in SEPT 2021. thanks for the amazing tip

My hero of the day !!!! thank you

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

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

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

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?

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

Awesome tricks ..... thanks a lot

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.

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?

Thanks it was really helpful

Thank you for sharing this!! :)

Bingo! You are awesome, Sir.

awsome 😃👍

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?

Wow! Thats Great! :-)

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.

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

Real help for my 200 MB+ xlsx spreadsheets

Thank you

This would be very helpful if a settings button existed. I have no settings button in my Outlook app.

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

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

REMOVE THIS STUPID VIDEO BECAUSE IT NO LONGER WORKS!!!!

Awesome tip, .thanks!

This is genius!

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

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

Tnx Bro .

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

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?

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

You might have saved me

Amazing!!!! Thank you!

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

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

I love it when "how to" video are straight to the point, clear and include a visual walkthrough. Top marks, very helpful.

and if it contains micro?

Is there any disadvantage of xlsb file?

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

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

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

Thanks Man!