Set Excel calculation to manual when you do not want to waste your time while excel calculates the formula after every event.
Sometimes our excel spreadsheet/dashboard contains huge volume of data and it takes a lot of time for excel to compute the formula after every event. Even if we don’t make any changes to a cell it recalculates and takes a significant amount of time to complete the operation.
By setting the calculation to manual we could explore the dashboard and save ourselves a lot of time.
Go to “Formula” tab and click on Calculation Options .As you can see below we could set the calculation to automatic or Manual depending on your requirement.
Hope this helped.