How to fix and boost Excel's calculation speed
Вставка
- Опубліковано 18 жов 2024
- We often can't understand errors in excel files with large data, slow calculation speed and sometimes endless calculations making it very difficult to work, let me share some tips & tricks to handle such excel files by understanding excel’s Calculation Mechanics and Background Process to fix such errors.
Thankyou for my improved exel tips you have been ginving me. Can you please be doing a vid on excel over 500MB with 100's of thousands of formulas for IP notation that isn't an option as a format cell function.
Very nice video Mr. Suleman !! Thank You !! Your videos are crisp, clear & to the point. As suggested below, would be really great to see some videos on Power query & Power pivot as well. Thank you.
I like your way of explanation very much. Wish to provide more advancef videos about Power Query and Power Pivot. Thanks
+Lotfy Kozman Thank you very much for your comments, and highlighting the areas needing attention,I will defiantly consider Power Query for upcoming sessions.
Thanks for these important tricks.
+Lotfy Kozman Good to know it was useful :) have a good day
Thanx alot
Thank you for watching the video and sharing your valuable comments here. Please stay in touch for more such videos on my channel
@@ExceltoExcelE u saved my tons of TIMES.thanx
After watching 20 youtube videos, 100% did not solve your problem. Let me pour a few cents here :
1) Delete the end cells (Shift+Ctrl+End), you need to delete whole rows & columns - 98% of slow excel problem
2) The others are not much help
- disable auto calculation
- dis-format especially conditional formatting
- Data validation
- Pivot table
- Macro
- Use better and shorter formula
Thank you, kind stranger.
Video starts at 2:00
Thanks alot for sharing your feedback here. All the best.
My humble request, don't waste our time, these are Doesn't solve at all.. except Manuel checking somewhat
Thanks
waste of my time
Thanks for the note and on the other hand Very sad to hear that you didn't find the video useful. If you could spare a couple of minutes and let me know why this video didn't meet your expectations so that I can cover it in my next vidoes would be a great help. Thanks again.
@@ExceltoExcelE good response