Magically Fixing Big Slow Excel files with a single click

The Inquire add in can fix large slow Excel workbooks with a single click

Follow me

[sedarathnadcd]

Thank you for bringing new knowledge to us every time.

[IvanCortinas_ES]

Over 20 years working with Excel and boom, I've always seen it, but never used it.
Great find Wyn! Thx.

[bc]

Thank you - I've been doing that cleanup by hand, so this will really help!

[GeertDelmulle]

Yes, I know about Inquire. I’ve used it sparingly for comparing workbooks. It’s also one of those add-ins that I have to activate every time I restart my computer.

[freezendog]

Hi Wyn, thanks for the tip, no didn't know, now installed!! I'll give this a go at some point, cheers!

[zuhairalmutawa]

Thank you, it was new to my knowledge.

[Bhavik_Khatri]

Never knew about it. I used Excel VBA to re-set the real last row and last column.

[AlphaWatt]

Very cool Wyn!! Thanks for sharing. Speaking of large files, my line of work requires evaluating hourly data sometimes in excess of 10 years (i.e. modeling a microgrid or battery simulation). I've spent a fair amount of time with no luck trying to avoid calculating everything at the datetime level but with a battery I need the resulting state of charge from the previous hour. Any suggestions? I'm not sure that using the Data Model would actually decrease my workbook size. Any help would be much appreciated!

[KO]

It's a shame that this is only available for the Pro or Enterprise versions.

[alexpoluk]

Thank you for another usefull video. I actually used to do it all the time but now as I switched to office 365 it's not there anymore. Any way to do something similar here?

[marybellandry]

I don't have this Inquire option available, however nifty tip!

[yosefk]

Awesome but unfortunately is not availlable on Microsoft 365 Subscription Edition.

[theohaigy]

I'll give this a try. I've got serious issues doing a simple cut and paste task on a 26mb file. It could also be a Mac issue. Copy and paste. No problem. But cut... Excel on Mac really doesn't like it.

[boffinschist]

I fixed my spreadsheet speed by disabling the Adobe Acrobat add-in the same com list as where turned on the Inquire

[amirhaynes]

1.56GB to - 1.11MB - A user contacted us regarding their excel file no longer opening. Thank you!

[AliensTech]

It's not a single click by the way 😂 But thank you for the trick.!!Good one

[bc]

Now if it would just get rid of all those extra cells... 😉

[medasbabu]

Oh this is not available for "Microsoft 365 Apps for business" :(

[subhassamuel]

Good Morning Sir, I am Subhas Samuel from India, I am a freelance Accountant and Tax Consultant, I would like to share one pathetic experience, recently I have visited a medium business organization, they are using one of the closed and preprogrammed Accounting Software, they are facing lots of problems, they are not able to ascertain their periodical business status, as I am an Excel user at Advanced level (not highly Advanced Level), the solution came to my mind so instantly that if they use latest version of Excel at Advanced level, they can get more than what they are not able to get with their present software, I have explained to them, still they do not want to give up their conservativeness, they prepared loose revenue rather than accepting radical changes, my assumption is they are loosing almost 35k dollars every year because of their inappropriate software usage, why I am sharing this experience is, this scenario is in prevalence all over the world among the business community ( The Ego), I am extremely sorry for using this word, Thanks and God Bless You Sir.