officemastery.com Open in urlscan Pro
149.28.169.89  Public Scan

Form analysis
1 forms found in the DOM

GET https://officemastery.com

<form class="tve-prevent-content-edit" role="search" method="get" action="https://officemastery.com">
  <div class="thrv-sf-submit" data-button-layout="icon" data-css="">
    <button type="submit">
      <span class="tcb-sf-button-icon">
        <span class="thrv_wrapper thrv_icon tve_no_drag tve_no_icons tcb-icon-inherit-style tcb-icon-display" data-css=""><svg class="tcb-icon" viewBox="0 0 512 512" data-id="icon-search-solid" data-name="" style="">
            <path
              d="M505 442.7L405.3 343c-4.5-4.5-10.6-7-17-7H372c27.6-35.3 44-79.7 44-128C416 93.1 322.9 0 208 0S0 93.1 0 208s93.1 208 208 208c48.3 0 92.7-16.4 128-44v16.3c0 6.4 2.5 12.5 7 17l99.7 99.7c9.4 9.4 24.6 9.4 33.9 0l28.3-28.3c9.4-9.4 9.4-24.6.1-34zM208 336c-70.7 0-128-57.2-128-128 0-70.7 57.2-128 128-128 70.7 0 128 57.2 128 128 0 70.7-57.2 128-128 128z">
            </path>
          </svg></span>
      </span>
      <span class="tve_btn_txt">Search</span>
    </button>
  </div>
  <div class="thrv-sf-input" data-css="" style="display: block;">
    <input type="search" placeholder="Search for ..." name="s" value="">
  </div>
  <input type="hidden" class="tcb_sf_post_type" name="tcb_sf_post_type[]" value="post" data-label="Post">
</form>

Text Content

__CONFIG_colors_palette__{"active_palette":0,"config":{"colors":{"a7948":{"name":"Main
Accent","parent":-1},"4824e":{"name":"Main Accent
Dark","parent":"a7948"}},"gradients":[]},"palettes":[{"name":"Default","value":{"colors":{"a7948":{"val":"var(--tcb-skin-color-0)"},"4824e":{"val":"rgb(8,
99,
129)","hsl_parent_dependency":{"h":195,"l":0.27,"s":0.88}}},"gradients":[]},"original":{"colors":{"a7948":{"val":"rgb(55,
179, 233)","hsl":{"h":198,"s":0.8,"l":0.56,"a":1}},"4824e":{"val":"rgb(35, 142,
188)","hsl_parent_dependency":{"h":198,"s":0.68,"l":0.43,"a":1}}},"gradients":[]}}]}__CONFIG_colors_palette__

 * Start Here
 * 5 Tenets
 * Blog
   * Search
   * Word
   * Excel
   * Beginners
 * Courses
   * Computers for the Terrified!
   * Beginners Word Bootcamp
   * Word Mastery
   * Beginners Excel Bootcamp
   * Excel Mastery
   * PowerPoint Mastery
   * Outlook Mastery
   * Publisher Mastery
   * Office Legends Academy
 * Member Login


WHEN TO USE AUTOMATIC VS MANUAL CALCULATIONS IN EXCEL

AUTHOR:  JASON MORRELL 



--------------------------------------------------------------------------------


Post Guide

1.  How on earth can you run out of rows in Excel?

2. Why do large spreadsheets run slow?

3. How to switch from automatic to manual calculations in Excel

4. What next?

--------------------------------------------------------------------------------

Reading Time:
 2 minutes remaining

Excel is set up to refresh calculations automatically and for most people that
is perfect. 

But there are situations where you NEED to switch to refreshing calculations
manually (on-demand) just to stay sane.

In this short post, you'll see some reasons for switching from automatic to
manual calculations as well as where to find the setting.


1.  HOW ON EARTH CAN YOU RUN OUT OF ROWS IN EXCEL?

Did you know that each Excel worksheet has 1, 048, 576 rows?

So imagine my surprise when one day I met someone who ran out of rows!

And not only that, this person ran out of rows every 10 -11 days!

Here's what was happening.

Special software fed live energy prices into a spreadsheet every second. The
data was then monitored and power was purchased and sold automatically to
wholesalers for a cent or two profit per unit, thousands of times each day.

And every few days the rows ran out!

By no means is this normal. In fact, hardly anyone reaches that point.

It's not just the sheer volume of data, but when a spreadsheet gets beyond a
certain size it becomes frustratingly S-L-O-W. Depending on the complexity of
the spreadsheet, this may occur with as few as 10,000 rows.


2. WHY DO LARGE SPREADSHEETS RUN SLOW?

Excel has a default setting that refreshed the worksheet (i.e. recalculates
every formula) whenever any change is made.

Even when you make a small change, you may have to wait a few seconds,  or even
a few minutes for Excel to complete its processing.

That's when you should turn AUTOMATIC CALCULATIONS off.


3. HOW TO SWITCH FROM AUTOMATIC TO MANUAL CALCULATIONS IN EXCEL

You have the option to switch off automatic calculations and control things
manually. This speeds things up considerably and gives you more control.

To switch to a manual calculation:

1.  Click the File tab.

2.  Choose Options in the left sidebar.

3.  In the Excel Options dialog, choose Formulas on the left sidebar.

4.  In the Calculation Options section, choose Manual.

Switch to manual calculations

Alternatively, 

1.  Click the Formulas tab

2.  Click Calculation Options on the right side. 

3.  Choose Manual.



To refresh your spreadsheet (recalculate manually on demand)

1.  Click the Formulas tab.

2.  Click Calculate Now (on the right side of the ribbon)

         ... or press F9 (which is a general key to update / refresh the
workbook).


4. WHAT NEXT?

Please feel free to post any questions you have into the comments below. And
before you leave this page, I want to give you one quick little action item! 

ACTION ITEM: Comment below with ONE thing you picked up from this post and share
how it has helped, or will help, you. It's good to share your successes because
it encourages others and provides an instant boost.

Enjoy the rest of your day!



About the author

Jason Morrell



--------------------------------------------------------------------------------

Jason loves to simplify the hard stuff, cut the fluff and share what actually
works. Things that make a difference. Things that slash hours from your daily
work tasks. He runs a software training business in Queensland, Australia, lives
on the Gold Coast with his wife and 4 kids and often talks about himself in the
third person!

SHARE

Share0
Tweet0
Share0


POPULAR EXCEL POSTS

How to display 1st, 2nd and 3rd on dates

--------------------------------------------------------------------------------

Where to find the best project management templates

--------------------------------------------------------------------------------

VLOOKUP de-mystfied

--------------------------------------------------------------------------------

How to display leading zeros on numbers

--------------------------------------------------------------------------------

How to best manage duplicates in Excel

--------------------------------------------------------------------------------

Don't Merge and Centre. Do this instead

--------------------------------------------------------------------------------

How to create dropdown lists

--------------------------------------------------------------------------------

Try these 3 ways to insert a degree symbol

--------------------------------------------------------------------------------

11 little-known sorting secrets (esp. 5, 6 and 9)

«« SEE ALL EXCEL POSTS »»


Search


Master Microsoft Office
in 30 days or less


LEARN MORE









more from



--------------------------------------------------------------------------------

Excel Power Tips

--------------------------------------------------------------------------------


SOS-CLICK: THE EASY AUTOMATED BACKUP TOOL FOR HOME USERS

Read More
SOS-Click: The Easy Automated Backup Tool For Home Users

--------------------------------------------------------------------------------

Excel Power Tips

--------------------------------------------------------------------------------


6 EXCEL TEMPLATES TO HELP ORGANIZE YOUR DAILY ACTIVITIES

Read More
6 Excel Templates to Help Organize Your Daily Activities

--------------------------------------------------------------------------------

Excel Power Tips

--------------------------------------------------------------------------------


10 WAYS EXCEL CONSULTANTS CAN HELP YOU FULLY LEVERAGE YOUR BUSINESS SPREADSHEETS

Read More
10 Ways Excel Consultants Can Help You Fully Leverage Your Business Spreadsheets

--------------------------------------------------------------------------------

Excel Formulas

--------------------------------------------------------------------------------


HOW TO FIX FORMULAS: 21 FATAL FORMULA FAILS (AND HOW TO AVOID THEM)

Read More
How to fix formulas: 21 Fatal Formula Fails (and how to avoid them)

JOIN THE DISCUSSION

comment_count comments
Newest
Newest
Oldest
Top rated comments first

<div class="tcm-extra-fields"> <div class="tcm-comment-additional-fields"> <div
class="inner clear-this"> <div class="tcm-guest"> <p>Comment as a guest: <div
class="tcm-error-message"> <input tabindex="1" id="tcm-guest-name"
class="form-input" type="text" name="name" placeholder="Name"/> <div
class="tcm-error-message"> <input tabindex="1" id="tcm-guest-email"
class="form-input" type="text" name="email" placeholder="Email (not displayed
publicly)"/> <label class="tcm_remember_me"> Save the details above in this
browser for the next time I comment <input id="tcm_remember_me"
class="form-input" type="checkbox" name="tcm_remember_me"/> <span
class="checkmark"> <button tabindex="1" class="tcm-save-btn tcm-truncate
tcm-transparent tcm-border-color-ac-h" id="tcm-submit-comment" data-parent="0"
data-level="0" type="submit"> Submit comment <div class="tcm-user-details"> <div
class="clear">


{"email":"Email address invalid","url":"Website address
invalid","required":"Required field missing"}
Copyright © 2022 Two Rivers Software Training. All Rights Reserved.
Guest writers Privacy Terms Contact
Close dialogue


Session expired

Please log in again. The login page will open in a new tab. After logging in you
can close it and return to this page.

>