Subscribe for access to this FREE e-learning mini-course!


Your First Name:


Your Surname:


Your Email Address:



Subscribe
Close


Small logo
Hamburger menu
Menu
bookings:   0333 6000 111
service:       0333 6000 555
    or           
Free Video Tutorials : Excel Formulas
Free Video Tutorials : Excel Formulas
Search

EXCEL FORMULAS: WHY A FORMULA DOESN'T WORK

Find out why your formula might not work in Microsoft Excel and how to fix it

Background information and resources for Excel courses that we hope you find useful

So you have spent a long time working on your spreadsheet, created some formulas, added some numbers to the cells. and nothing happens. There are many reasons for this, so here are a few to check.

THE MOST COMMON CAUSES

One very common reason when totals are not adding up can be found with a simple click of the mouse. Someone has overwritten the formula! Often, if there is a spreadsheet shared between and used by many different colleagues, it may be that somebody has deleted a formula or overwritten it by adding a number to the cell.

If your colleague brings one of these queries to you, open the file and on the formulas tab, click the Show Formulas button. Are there any inconsistencies? Is there a number where a formula should be? Change it back to a formula, which will usually involve copying the formula down from the cell above. It is probably wise to look at protecting the sheet which enables you to specify cells that people are allowed to work in and locks everything else.

The Most Common Causes

IS MANUAL CALCULATION SELECTED?

If you have a huge spreadsheet with thousands of formulas, it might be a good idea to set calculation options to Manual since too many formulas will slow down the running of your sheet. Go to the Formulas tab and set calculation options to Manual.

Is Manual Calculation Selected?

This now means that formulas will not update until you recalculate the sheet by clicking the Calculate Now button or pressing F9 on your keyboard.

So if your formulas are not updating, this might be set to manual. Reset your Calculation Options to Automatic, then see whether this does the trick.

Another reason is that your formulas are incorrect or looking at the wrong cell. The Formulas tab has a whole host of options to help you trace formulas or to locate any errors so this is usually a good place to go if your answer is not what it should be.

WE HOPE YOU FOUND THIS USEFUL

Want to see how we can really help you?

LINKS TO MORE ...

Main Excel Resources Page

Excel Resources

Video tutorials & articles, and templates to help you work better in Excel

      Click to view

 

Video Tutorials - Excel Formulas

Video Tutorials - Excel Formulas

Learn and work with new Excel formulas to help create effective, automated spreadsheets

Click to view

Excel Formulas: Circular reference warning

Excel Formulas: Circular reference warning

See what a Circular Reference warning means and how to locate it in your Excel spreadsheet

      Click to read more

 

Excel Formulas: Calculate difference in dates

Excel Formulas: Calculate difference in dates

Learn how to calculate the difference between two dates in your Excel spreadsheet in a few easy steps

      Click to read more

Excel Formulas: How to work out gross profit

Excel Formulas: How to work out gross profit

Find out how to use a formula to work out gross profit in Microsoft Excel

      Click to read more

 

Excel Formulas: The DATEDIF function

Excel Formulas: The DATEDIF function

Find out what the DATEDIF function is and how to use it in Microsoft Excel

      Click to read more

GET IN TOUCH

Call us on:
0333 6000 111

   You can Email us direct (You'll usually get a response within 2-3 working hours)
   Or fill out the details below and we'll be in touch very soon:
SEND MESSAGE

WHY A FORMULA DOESN'T WORK IN EXCEL

We can enhance your skills with courses for Microsoft Excel spreadsheets at any of our twelve training centres UK wide, or we can come to your offices: if you have groups of three or more staff who need training, this is a very convenient, flexible and cost effective option. Moreover, most of our excel courses are 1 day, which keeps "out of office" periods for attendees to a minimum.

We have been delivering Microsoft Excel course all over the UK since 1995 and have continually developed our philosophy of high quality, flexible and results-driven provision of courses for Excel to ensure constantly improving standards of quality.   So you can be confident that we have the expertise, and the experience, to give you a great return on your investment in Free Video Tutorials : Excel Formulas.

Why not contact us today to see how we can help with providing your MS Excel classes ?


Stay in touch

Stay In Touch!

Google+
LinkedIn
Twitter
FaceBook
YouTube

Contact Details

Activia Training

Locations Address: Head Office, Regus House,
268 Bath Road
Slough, Berkshire SL1 4DX

Phone Sales:           0333 6000 111

Service:       0333 6000 555

Accounts:   0333 6000 777



Back to top