Excel Tip - Speed up Slow Workbooks Turn Off Automatic Formula Calculation

Поделиться
HTML-код
  • Опубликовано: 28 окт 2024

Комментарии • 17

  • @rummyfilms633
    @rummyfilms633 4 года назад +1

    Thanks it saved my time

  • @robertminicucci7968
    @robertminicucci7968 6 лет назад

    Thanks for this -- was going mental trying to turn it off.

  • @solovino861
    @solovino861 8 лет назад

    I'm trying to put two formulas in one cell through a pull down tab. but when I put the formula in the second sheet it tries to solve itself and gives me zeros. So the pull down tab will end up giving me zeros instead of the formulas. Is what I'm trying to do possible?

  • @TeachExcel
    @TeachExcel  13 лет назад

    @CAMACORP For the most part, the only things to do are to turn of auto calculation on save. If you have a really big workbook with a lot of data, there is little you will be able to do since the new excel format compresses data on saving.

  • @bobbyjojo
    @bobbyjojo 6 лет назад

    I am having a problem with Excel crashing on some pages. Can I get some help?

  • @sadiqtanoli1
    @sadiqtanoli1 4 года назад

    Thank u. But Farmulas do not wrking after change at manual

    • @TeachExcel
      @TeachExcel  4 года назад

      You need to change it back to automatic for that. I know that sometimes it won't be viable to switch back and forth often, but if you want all formulas to update whenever data changes, calculations must be on automatic.

  • @tisyaAI
    @tisyaAI 5 лет назад

    Thanks a lot, it saved my lot of time.. great help

  • @laxmimiskin254
    @laxmimiskin254 3 года назад

    Link to VBA code* for auto caulation.

  • @junramos9144
    @junramos9144 4 года назад

    thank you, big help

  • @vatsalvohra421
    @vatsalvohra421 7 лет назад

    Tysm man u r gr8 n olso a genius..👍

  • @footballsoccerreferee6152
    @footballsoccerreferee6152 6 лет назад

    Thanks!

  • @palmaraja4850
    @palmaraja4850 4 года назад

    I've been studying speeding up Macs and discovered a fantastic resource at Achak Speed Plan (check it out on google)

  • @mywisdomseed
    @mywisdomseed 9 лет назад

    Thanks that solved my S**ty MS excel prob....:)

  • @solovino861
    @solovino861 8 лет назад

    I'm trying to put two formulas in one cell through a pull down tab. but when I put the formula in the second sheet it tries to solve itself and gives me zeros. So the pull down tab will end up giving me zeros instead of the formulas. Is what I'm trying to do possible?