How to FIX Your SLOW Excel File
ฝัง
- เผยแพร่เมื่อ 1 ต.ค. 2024
- Join 300,000+ professionals in our courses: www.xelplus.co...
Say goodbye to slow Excel files! In this video I'll show you a new feature in Excel for the web to optimize your Excel spreadsheet: Check Performance. It looks for unnecessary formatting, metadata and styles that might be cluttering up your large workbook. It provides suggestions for each sheet and you can choose to optimize. This can reduce the size of your file by a huge amount and turn your slow workbooks into super fast loading files.
🌍 My Online Excel Courses ► www.xelplus.co...
🎬 LINK to more TH-cam Shorts videos: • Shorts (Tips, Tricks &...
👕☕ Get the Official XelPlus MERCH: xelplus.creato...
🎓 Not sure which of my Excel courses fits best for you? Take the quiz: www.xelplus.co...
📚 Excel RESOURCES I Recommend: www.xelplus.co...
🎥 GEAR I use: www.xelplus.co...
More resources on my Amazon page: www.amazon.com...
🚩Let’s connect on social:
Instagram: / lgharani
Twitter: / leilagharani
LinkedIn: / leilagharani
👉 This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!
#Excel #shorts
I do this manually..
just select all rows and columns except the data part and ‘right click and delete’.
This removes all formatting and reduces size drastically.
Nice to see this as feature. Waiting eagerly to try it..
Wow!
Thank you, @ Leila Gharani for this tip, and so many more!
You're so welcome!
Super helpful thanks Leila!
My excel do very much legging in new laptop when I put mouse point on any cell its selected to another cell mean . like if I selected G5 cell with mouse than its select another cell , i take help of microsoft support team and they share my screen also but they are unable to detect my problems how I can fix its
The check performance doesn’t show up in my ribbon options..
hmm I'm not seeing this option either with Excel on the Web. Thank you for the heads up though.
I hoped something like that exists! Amazing ❤
I didn’t expect that unused formatting could be that space-consuming…
Brilliant yet again! 👌
I don't have this feature on Excel on the web yet, but a great thing to know MS is trying to fix slow workbooks
i love how every video on this topic is like "and we'll show you how to fix it! all you need is a M365 account because there's this new feature.." we're in 2023 and i guess that makes office 2021 completely obsolete?
Question, if I'm using the Excel DT App, can I do this there or do I need to upload it to the web version, Optimize, and then save back to local copy for DT App to use?
Have you ever received a huge file, that Excel will refuse to open it? If yes, how could we solve it?
(Just curiosity)
What if your amazing spreadsheet is 125mb in size? Lol
Great
את נחמדה אני מהאב בח
😍
How come my Excel doesn't have this feature?
Nice one!
I love this. Have done it to a file that I share with many colleagues from work and could reduce it by almost 30%. Thank you
Excellent feature especially if you’re constantly sending out batches of data out via email 😅
My biggest one has around 40mb so I will have to see what can be done :D
100K rows ,,, any idea :(
Leila is much better than ChatGPT.
This is super needed information. I wish i knew 1 week back....
Does the desktop version have this feature?
We don’t have this yet 😂
Mam, if a cell contains number of words vertically in excel then how to split it in separate cells in multiple rows?
Please reply
Usa a combination of Excel and Word:
For the cell with the text you want to split, use the formula bar to select and copy the data.
Switch to Word.
Paste the contents into Word.
Manipulate the contents into as many lines as there will be cells necessary for the Excel spreadsheet.
Copy the manipulated Word data.
Switch to Excel.
Paste the data in the appropriate destination/cells. Note that if there were cells with data below the original cell, those cells' data will be overwritten with the pasted data.
Brilliant! ❤
This is really really helpful. More power to u Leila 👍
Thankssss.... It Helped Me....
Super useful! Thank you 😊 💓
How to do it in older versions ?
You have to open the sheet on the web?
Maybe the feature is not available yet in the Greek version of Excel online, as there is nothing between "Workbook Statistics" and "Check Accessibility" tabs under the "Review" pull down menu. I hope Microsoft includes it in a future update, as it can be life saving.
I think she said it was only in the online version of Excel
@FSCHW I know, that's what I said too.
This great. Thank you
This is great... but I can't see this in my excel. How do I get it please? Ty
It's currently for the web version. So go to Office.com and open your file from OneDrive. It will hopefully come to desktop as well.
Do we need to have a Microsoft account to open web ?
Useful one, Thanks a lot
😮 so incredible…
Great tip and I wish I knew about this earlier. You mention this is Excel on web, is this available on desktop version as well?
Not yet. But hopefully it will be at some point.
Thanks for reply. Love your videos.
As someone who is always OCD ing about file size this is quite amazing
128mb spreadsheet coming through
Thank you!
amazing..
Nice!
Good 👍👌
Amazing
Amazing!!
How to delete inactive defined name no more in use
Goto Name manager.. delete it there
@@martyc5674 names are inactive I can't make a move
@@mosabhadi866 I don’t understand you fully- where do u see the named ranges?
Search Excel's Help for the Name Manager feature.
Ribbon > tab Formulas > group Defined Names > Name Manager
4.9 is very small. What if I got 75 to 166 mb file
Press Ctrl End in each sheet.. you’ll find you have probably formatted a few million cells that are never looked at.