The Inquire add in can fix large slow Excel workbooks with a single click support.micros... Follow me wyn.bio.link/ For training and Consulting in Perth Western Australia see accessanalytic...
Пікірлер: 50
@sedarathnadcd2 жыл бұрын
Thank you for bringing new knowledge to us every time.
@AccessAnalytic2 жыл бұрын
You’re welcome e Priya
@IvanCortinas_ES2 жыл бұрын
Over 20 years working with Excel and boom, I've always seen it, but never used it. Great find Wyn! Thx.
@AccessAnalytic2 жыл бұрын
Cheers Iván
@GeertDelmulle2 жыл бұрын
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.
@AccessAnalytic2 жыл бұрын
That used to happen to me with certain add-ins. DAX Studio is one that still does that
@AccessAnalytic2 жыл бұрын
I have the Developer Tab enabled to make it easier to toggle COM addins off and back on
@GeertDelmulle2 жыл бұрын
@@AccessAnalytic Funny, for me the DAX Studio add-in doesn’t do that. And yes, all ribbon tabs are active (bar one) all the time, even the Access Analytic one :-) I even put the Options and Advanced Options buttons on my QAT for quick access.
@bc41982 жыл бұрын
Thank you - I've been doing that cleanup by hand, so this will really help!
@AccessAnalytic2 жыл бұрын
No worries B C
@Siphokazi_Fikeni Жыл бұрын
Wow! From 45mb to 1mb. Magic! Thanks
@AccessAnalytic Жыл бұрын
Awesome!
@freezendog72 жыл бұрын
Hi Wyn, thanks for the tip, no didn't know, now installed!! I'll give this a go at some point, cheers!
@AccessAnalytic2 жыл бұрын
Great, thanks for letting me know Pete
@Bhavik_Khatri2 жыл бұрын
Never knew about it. I used Excel VBA to re-set the real last row and last column.
@marybellandry2975 Жыл бұрын
I don't have this Inquire option available, however nifty tip!
@AccessAnalytic Жыл бұрын
Thanks
@zuhairalmutawa9941 Жыл бұрын
Thank you, it was new to my knowledge.
@AccessAnalytic Жыл бұрын
Glad to help
@AlphaWatt2 жыл бұрын
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!
@AccessAnalytic2 жыл бұрын
I'd almost guarantee that using the Data Model would decrease your workbook size. I'd recommend you post some sample data and screenshots to techcommunity.microsoft.com/t5/microsoft-excel/ct-p/Excel_Cat or to the Power BI community community.powerbi.com/t5/Desktop/bd-p/power-bi-designer to get the data model / DAX approach to address your scenario
@AlphaWatt2 жыл бұрын
@@AccessAnalytic great suggestions. You’ve got me thinking with the DAX approach. Thanks for sharing the links. I’ll gather my thoughts and reach out to the community if I can’t overcome. Thanks again!
@KO19672 жыл бұрын
It's a shame that this is only available for the Pro or Enterprise versions.
@AccessAnalytic2 жыл бұрын
Yep, there's a number of odd decisions with these sorts of things about what to include / exclude
@jumanarimawi13327 ай бұрын
you saved my day :) , subscribed!
@AccessAnalytic7 ай бұрын
Great! Welcome 😀
@yosefk28642 жыл бұрын
Awesome but unfortunately is not availlable on Microsoft 365 Subscription Edition.
@AccessAnalytic2 жыл бұрын
Thanks. It's these 365 subscriptions: www.microsoft.com/en-au/microsoft-365/enterprise/compare-office-365-plans
@alexpoluk98642 жыл бұрын
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?
@AccessAnalytic2 жыл бұрын
My demo is using 365
@AccessAnalytic2 жыл бұрын
But it's E3 (enterprise, so I'm guessing you don't have that version)
@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.
@AccessAnalytic Жыл бұрын
Doesn’t sound good
@boffinschist1098 Жыл бұрын
I fixed my spreadsheet speed by disabling the Adobe Acrobat add-in the same com list as where turned on the Inquire
@AccessAnalytic Жыл бұрын
Good stuff
@ArcadiaVibe Жыл бұрын
1.56GB to - 1.11MB - A user contacted us regarding their excel file no longer opening. Thank you!
@AccessAnalytic Жыл бұрын
Awesome!
@Hendrix917 Жыл бұрын
double like!!
@AccessAnalytic Жыл бұрын
Double thanks 😀
@amamoh2 жыл бұрын
My file got bigger after this :P
@AccessAnalytic2 жыл бұрын
Wow? 😳. Make sure you send feedback to the Excel team via File - Feedback - send a frown
@AliensTech2 жыл бұрын
It's not a single click by the way 😂 But thank you for the trick.!!Good one
@AccessAnalytic2 жыл бұрын
Never let facts get in the way of a headline 😁
@medasbabu2 жыл бұрын
Oh this is not available for "Microsoft 365 Apps for business" :(
@AccessAnalytic2 жыл бұрын
Sadly not
@bc41982 жыл бұрын
Now if it would just get rid of all those extra cells... 😉
@subhassamuel31622 жыл бұрын
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.
@AccessAnalytic2 жыл бұрын
Interesting
@dareshallany20412 күн бұрын
Hi, do you have any tips for fixing large excel files for people who work for companies who don't allow third party add ins?
@AccessAnalytic11 күн бұрын
I’ve never seen this particular addin turned off. But…there’s a new feature on the review tab called Optimise Worksheet that might help ( if you have an up to date version of 365 )