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

Поділитися
Вставка
  • Опубліковано 30 жов 2024

КОМЕНТАРІ • 65

  • @ap.melmugampaccs4038
    @ap.melmugampaccs4038 2 роки тому

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

    • @Prabasmsoffice
      @Prabasmsoffice  2 роки тому

      Prabas@prabastech.com
      என்ற மினஞ்சல் இற்கு உங்கள் ஃபைல் ஐ அனுப்பி வைக்கவும் நான் நேரம் உள்ளபோது அதை பார்கிறேன்.

  • @ebin1311
    @ebin1311 5 років тому +3

    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
      @Prabasmsoffice  5 років тому

      Thanks for your real-time comment. Keep supporting.

    • @ebin1311
      @ebin1311 5 років тому +1

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

    • @Prabasmsoffice
      @Prabasmsoffice  5 років тому

      Sure Ebin.

    • @ebin1311
      @ebin1311 5 років тому +1

      @@Prabasmsoffice Thankyou sir

  • @sheeladevipushpa7884
    @sheeladevipushpa7884 5 років тому +2

    Very Very useful vedieo Thank You so much.

  • @aaroajith7809
    @aaroajith7809 5 років тому +2

    Very useful Tips

    • @Prabasmsoffice
      @Prabasmsoffice  5 років тому

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

  • @LifeofVIJAY96
    @LifeofVIJAY96 4 роки тому +2

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

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      Thanks for appreciating Us. Keep supporting.

  • @vanjibanu8200
    @vanjibanu8200 5 років тому +2

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

  • @ChandraMohan-sm6cp
    @ChandraMohan-sm6cp 5 років тому +2

    Good information.thanks

    • @Prabasmsoffice
      @Prabasmsoffice  5 років тому

      Hi Mohan, Thanks for your positive comment.

    • @premjangra.dhanialla
      @premjangra.dhanialla 4 роки тому

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

  • @CarCraze-VimalKumar
    @CarCraze-VimalKumar 5 років тому +2

    Bro lot of information. Super 👍👌

  • @gopis-musicaljourney6124
    @gopis-musicaljourney6124 3 роки тому +1

    Very useful and detailed explanation 👍👌👏 bro

    • @Prabasmsoffice
      @Prabasmsoffice  3 роки тому +1

      What the rest of the videos too.

    • @gopis-musicaljourney6124
      @gopis-musicaljourney6124 3 роки тому +1

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

    • @Prabasmsoffice
      @Prabasmsoffice  3 роки тому +1

      Glad to hear

  • @TheKamaladasan
    @TheKamaladasan 5 років тому +1

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

  • @Manikandan-eh1hj
    @Manikandan-eh1hj 5 років тому +3

    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
    @akshaywadiya5749 3 роки тому +1

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

  • @manikandanrajamani1171
    @manikandanrajamani1171 2 роки тому +1

    Super

  • @Sriram-hz2gz
    @Sriram-hz2gz Рік тому

    Thanks Sir,🙏

  • @ajithsha823
    @ajithsha823 4 роки тому +1

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

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      Share your problematic file to prabas.msoffice@gmail.com. I will review and try to help you.

  • @mohanraju9743
    @mohanraju9743 4 роки тому +1

    Super ji!!!!

    • @Prabasmsoffice
      @Prabasmsoffice  4 роки тому

      Thanks for posting your comment Mohan Raju. Keep supporting.

  • @karthickrajalearn
    @karthickrajalearn 5 років тому +1

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

    • @Prabasmsoffice
      @Prabasmsoffice  5 років тому

      Thanks for highlighting this option. Keep learning.

  • @rajasanthosh9617
    @rajasanthosh9617 5 років тому +1

    Fantastic sir

    • @Prabasmsoffice
      @Prabasmsoffice  5 років тому

      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
    @massmoorthi9050 5 років тому +2

    Can you pls upload a video about tally ??

    • @Prabasmsoffice
      @Prabasmsoffice  5 років тому

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

  • @sredharbalaraman1387
    @sredharbalaraman1387 5 років тому +1

    Nice bro

    • @Prabasmsoffice
      @Prabasmsoffice  5 років тому +1

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

  • @kalpanadevi1162
    @kalpanadevi1162 4 роки тому +2

    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
      @Prabasmsoffice  4 роки тому

      I have to see the exact problem that you have.
      Record your problem as a video and share it me me. prabas.msoffice@gmail.com

  • @sebastianlukas5525
    @sebastianlukas5525 4 роки тому +1

    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
    @netheshnano1909 4 роки тому +1

    Shortcut key to select upto cell with data ?

  • @itsmenm8399
    @itsmenm8399 2 роки тому

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

    • @Prabasmsoffice
      @Prabasmsoffice  2 роки тому

      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
    @NVenkadesh 5 років тому +1

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

    • @Prabasmsoffice
      @Prabasmsoffice  5 років тому +1

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

    • @Prabasmsoffice
      @Prabasmsoffice  5 років тому +1

      Keep utilising the technology.

    • @NVenkadesh
      @NVenkadesh 5 років тому

      Sure, I always try to utilise it. Thanks

  • @premjangra.dhanialla
    @premjangra.dhanialla 4 роки тому

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

  • @senthilanandan4141
    @senthilanandan4141 2 роки тому

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

  • @hektora
    @hektora 4 роки тому

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