Secret Tips and Tricks to Control Slowness of an Excel File | Excel Problem Solving | in Tamil

[@ap.melmugampaccs4038]

sir, நான் Excelல் ஒரு Program செய்திருந்தேன். அதன் File Size Below 5MB உள்ளது. இதில் Multiple Sheetல் Formula உபயோகித்து Pictureம வருமாறு Program செய்திருந்தேன். இதனை வேறு ஒருவருக்கு வழங்கினேன். அதில் அவர் சில நாட்கள் பயன்படுத்தி அவருடை பணிகளை செய்து வந்தார். பின்னர் ஒருநாள் இதில் உள்ள file சரிவர இயங்கவில்லை என தெரிவித்தார். இதனை நான் பெற்று Check செய்த வகையில் இந்த Program தயார் செய்த என்னால் இதில் ஏற்பட்ட Problem சரி செய்ய இயலவில்லை. (குறிப்பு: இந்த Excel Fileல் சுமார் 25 Sheet பயன் படுத்தியுள்ளேன்) அந்த Excel File தங்களுக்கு அனுப்ப வேண்டுமானால் எவ்வாறு அனுப்புவது என்பதை தெரிய படுத்தவும்.

[@Prabasmsoffice]

[e-mail]
என்ற மினஞ்சல் இற்கு உங்கள் ஃபைல் ஐ அனுப்பி வைக்கவும் நான் நேரம் உள்ளபோது அதை பார்கிறேன்.

[@ebin1311]

sir this is first time I have learned that unwanted formating consume memory even data is not filled, the same mistake i have done in my work , now I'm corrected
Many thanks for the video.

[@Prabasmsoffice]

Thanks for your real-time comment. Keep supporting.

[@ebin1311]

@@Prabasmsoffice sir I have request will you pl start a session on BI.
Thankyou sir.

[@Prabasmsoffice]

Sure Ebin.

[@ebin1311]

@@Prabasmsoffice Thankyou sir

[@sheeladevipushpa7884]

Very Very useful vedieo Thank You so much.

[@Prabasmsoffice]

Keep watching and supporting.

[@aaroajith7809]

Very useful Tips

[@Prabasmsoffice]

Thanks for watching the video. Subscribe to PrabasMsoffice for regular updates.

[@LifeofVIJAY96]

Super sir.....thq for your work..

[@Prabasmsoffice]

Thanks for appreciating Us. Keep supporting.

[@vanjibanu8200]

Super sir thanks..........

[@Prabasmsoffice]

Thanks Vanji Banu

[@ChandraMohan-sm6cp]

Good information.thanks

[@Prabasmsoffice]

Hi Mohan, Thanks for your positive comment.

[@premjangra.dhanialla]

@@Prabasmsoffice sir total excel 9230
But just 9000 to next sheet verry hanging problam

[@CarCraze-VimalKumar]

Bro lot of information. Super 👍👌

[@Prabasmsoffice]

Thanks for your feedback.

[@gopis-musicaljourney6124]

Very useful and detailed explanation 👍👌👏 bro

[@Prabasmsoffice]

What the rest of the videos too.

[@gopis-musicaljourney6124]

Yeah , I'm started looking ur videos from yesterday only. Bro...I need to learn lots of thinks from u.. thanks much.

[@Prabasmsoffice]

Glad to hear

[@TheKamaladasan]

Thank you very, very much sir. Superb. and very useful tips.

[@Prabasmsoffice]

Thanks for following PrabasMsoffice. Keep sharing with your friends.

[@TheKamaladasan]

Ok sir

[@Manikandan-eh1hj]

Dear sir
One issue
I am newly installed MSOffice 360
But I am open excel file but open two files how solve my problem pls give me better resolution

[@akshaywadiya5749]

Please make this video in English language either Hindi language..

[@manikandanrajamani1171]

Super

[@Sriram-hz2gz]

Thanks Sir,🙏

[@ajithsha823]

Hi sir i like your video enaku excel sheet la same problems i tray but notable

[@Prabasmsoffice]

Share your problematic file to [e-mail]. I will review and try to help you.

[@mohanraju9743]

Super ji!!!!

[@Prabasmsoffice]

Thanks for posting your comment Mohan Raju. Keep supporting.

[@karthickrajalearn]

In 13m 38 sec
Awesome Option
Recalculate Saving Workbook before closing

[@Prabasmsoffice]

Thanks for highlighting this option. Keep learning.

[@rajasanthosh9617]

Fantastic sir

[@Prabasmsoffice]

Thanks Raja for watching the video. Try to clear the formatting and see the impact in the file size. Downloadable practice file is ready in our usual location.

[@massmoorthi9050]

Can you pls upload a video about tally ??

[@Prabasmsoffice]

Thanks for your interest. No idea to take tally now, I will announce it in future if any.

[@sredharbalaraman1387]

Nice bro

[@Prabasmsoffice]

Thanks for liking this video Sredhar.
1st comment of this video, thanks once again.

[@kalpanadevi1162]

Hello sir
Excell la upper case use panni names captital letters la vanthalum small letter la iruka collum delete panna mudiyala delete pannal lower case and chage upper case name delete aguthu pls konjam solikudunga sir

[@Prabasmsoffice]

I have to see the exact problem that you have.
Record your problem as a video and share it me me. [e-mail]

[@sebastianlukas5525]

Sir I'm using Android Excel app na bike seser work pandra so adhanala na fast ha type pannanum but panna mudiyala apdeya slow type agudhu app hanging agudhu help me sir

[@netheshnano1909]

Shortcut key to select upto cell with data ?

[@itsmenm8399]

After doing entry in cell to move next cell it's taking cell calculating it takes only Seconds but can't work faster

[@Prabasmsoffice]

Yes, it happens. If you use heavy Formula refering huge range and external cell reference, it may take time to process.
Disabling automatic calculation will help you. Try it.

[@NVenkadesh]

Thanks for the tips. I think it could be little more crispy. I used 1.75 X speed to go through the content..

[@Prabasmsoffice]

Good venkadesh, saving time is very important. 1.7x is a good idea.

[@Prabasmsoffice]

Keep utilising the technology.

[@NVenkadesh]

Sure, I always try to utilise it. Thanks

[@premjangra.dhanialla]

Excel book is very slow sir
Total cell 9300
But this problem start 9000 cell next

[@Prabasmsoffice]

Have you used any heavy formula in tht specific row?

[@premjangra.dhanialla]

@@Prabasmsoffice no sir
Only simple entry

[@premjangra.dhanialla]

Please give me your whatsapp no
I send you photo and video

[@Prabasmsoffice]

[e-mail]

[@Prabasmsoffice]

Excel is required to support you better

[@senthilanandan4141]

Thank you very much. pls, avoid too much speaking...

[@Prabasmsoffice]

Point taken

[@hektora]

WHY YOU ARE POSTING ENGLSIH TITLE TO NOT ENGLISH VIDEO??? JOKE!