Magically Fixing Big Slow Excel files with a single click

  Рет қаралды 53,497

Access Analytic

Access Analytic

Күн бұрын

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
@sedarathnadcd
@sedarathnadcd 2 жыл бұрын
Thank you for bringing new knowledge to us every time.
@AccessAnalytic
@AccessAnalytic 2 жыл бұрын
You’re welcome e Priya
@IvanCortinas_ES
@IvanCortinas_ES 2 жыл бұрын
Over 20 years working with Excel and boom, I've always seen it, but never used it. Great find Wyn! Thx.
@AccessAnalytic
@AccessAnalytic 2 жыл бұрын
Cheers Iván
@GeertDelmulle
@GeertDelmulle 2 жыл бұрын
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.
@AccessAnalytic
@AccessAnalytic 2 жыл бұрын
That used to happen to me with certain add-ins. DAX Studio is one that still does that
@AccessAnalytic
@AccessAnalytic 2 жыл бұрын
I have the Developer Tab enabled to make it easier to toggle COM addins off and back on
@GeertDelmulle
@GeertDelmulle 2 жыл бұрын
@@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.
@bc4198
@bc4198 2 жыл бұрын
Thank you - I've been doing that cleanup by hand, so this will really help!
@AccessAnalytic
@AccessAnalytic 2 жыл бұрын
No worries B C
@Siphokazi_Fikeni
@Siphokazi_Fikeni Жыл бұрын
Wow! From 45mb to 1mb. Magic! Thanks
@AccessAnalytic
@AccessAnalytic Жыл бұрын
Awesome!
@freezendog7
@freezendog7 2 жыл бұрын
Hi Wyn, thanks for the tip, no didn't know, now installed!! I'll give this a go at some point, cheers!
@AccessAnalytic
@AccessAnalytic 2 жыл бұрын
Great, thanks for letting me know Pete
@Bhavik_Khatri
@Bhavik_Khatri 2 жыл бұрын
Never knew about it. I used Excel VBA to re-set the real last row and last column.
@marybellandry2975
@marybellandry2975 Жыл бұрын
I don't have this Inquire option available, however nifty tip!
@AccessAnalytic
@AccessAnalytic Жыл бұрын
Thanks
@zuhairalmutawa9941
@zuhairalmutawa9941 Жыл бұрын
Thank you, it was new to my knowledge.
@AccessAnalytic
@AccessAnalytic Жыл бұрын
Glad to help
@AlphaWatt
@AlphaWatt 2 жыл бұрын
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!
@AccessAnalytic
@AccessAnalytic 2 жыл бұрын
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
@AlphaWatt
@AlphaWatt 2 жыл бұрын
@@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!
@KO1967
@KO1967 2 жыл бұрын
It's a shame that this is only available for the Pro or Enterprise versions.
@AccessAnalytic
@AccessAnalytic 2 жыл бұрын
Yep, there's a number of odd decisions with these sorts of things about what to include / exclude
@jumanarimawi1332
@jumanarimawi1332 7 ай бұрын
you saved my day :) , subscribed!
@AccessAnalytic
@AccessAnalytic 7 ай бұрын
Great! Welcome 😀
@yosefk2864
@yosefk2864 2 жыл бұрын
Awesome but unfortunately is not availlable on Microsoft 365 Subscription Edition.
@AccessAnalytic
@AccessAnalytic 2 жыл бұрын
Thanks. It's these 365 subscriptions: www.microsoft.com/en-au/microsoft-365/enterprise/compare-office-365-plans
@alexpoluk9864
@alexpoluk9864 2 жыл бұрын
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?
@AccessAnalytic
@AccessAnalytic 2 жыл бұрын
My demo is using 365
@AccessAnalytic
@AccessAnalytic 2 жыл бұрын
But it's E3 (enterprise, so I'm guessing you don't have that version)
@theohaigy
@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
@AccessAnalytic Жыл бұрын
Doesn’t sound good
@boffinschist1098
@boffinschist1098 Жыл бұрын
I fixed my spreadsheet speed by disabling the Adobe Acrobat add-in the same com list as where turned on the Inquire
@AccessAnalytic
@AccessAnalytic Жыл бұрын
Good stuff
@ArcadiaVibe
@ArcadiaVibe Жыл бұрын
1.56GB to - 1.11MB - A user contacted us regarding their excel file no longer opening. Thank you!
@AccessAnalytic
@AccessAnalytic Жыл бұрын
Awesome!
@Hendrix917
@Hendrix917 Жыл бұрын
double like!!
@AccessAnalytic
@AccessAnalytic Жыл бұрын
Double thanks 😀
@amamoh
@amamoh 2 жыл бұрын
My file got bigger after this :P
@AccessAnalytic
@AccessAnalytic 2 жыл бұрын
Wow? 😳. Make sure you send feedback to the Excel team via File - Feedback - send a frown
@AliensTech
@AliensTech 2 жыл бұрын
It's not a single click by the way 😂 But thank you for the trick.!!Good one
@AccessAnalytic
@AccessAnalytic 2 жыл бұрын
Never let facts get in the way of a headline 😁
@medasbabu
@medasbabu 2 жыл бұрын
Oh this is not available for "Microsoft 365 Apps for business" :(
@AccessAnalytic
@AccessAnalytic 2 жыл бұрын
Sadly not
@bc4198
@bc4198 2 жыл бұрын
Now if it would just get rid of all those extra cells... 😉
@subhassamuel3162
@subhassamuel3162 2 жыл бұрын
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.
@AccessAnalytic
@AccessAnalytic 2 жыл бұрын
Interesting
@dareshallany204
@dareshallany204 12 күн бұрын
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?
@AccessAnalytic
@AccessAnalytic 11 күн бұрын
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 )
3 Essential Excel skills for the data analyst
18:02
Access Analytic
Рет қаралды 1,5 МЛН
Fix the Most Common Causes of Slow Excel Files (Free Files Included)
9:50
MyOnlineTrainingHub
Рет қаралды 64 М.
Hoodie gets wicked makeover! 😲
00:47
Justin Flom
Рет қаралды 68 МЛН
Disrespect or Respect 💔❤️
00:27
Thiago Productions
Рет қаралды 34 МЛН
Perfect Pitch Challenge? Easy! 🎤😎| Free Fire Official
00:13
Garena Free Fire Global
Рет қаралды 71 МЛН
Possible Solutions to fix Excel files that are huge
14:58
Excel to Excel
Рет қаралды 5 М.
Excel Tables - Tutorial  ( Excel's 2nd best feature )
15:12
Access Analytic
Рет қаралды 5 М.
Stop Wasting Time! 3 Easy Ways to Remove Blank Rows in Excel
10:20
Leila Gharani
Рет қаралды 123 М.
Handle millions of rows in Excel - Large slow files? - use Data Model
10:39
Efficiency 365 by Dr Nitin
Рет қаралды 11 М.
How to Resolve Excel Running Slow? [6 Solutions]
7:53
Wondershare Repairit
Рет қаралды 69 М.
10 Million Rows of data Analyzed using Excel's Data Model
10:57
Access Analytic
Рет қаралды 118 М.
Hoodie gets wicked makeover! 😲
00:47
Justin Flom
Рет қаралды 68 МЛН