Common Excel Problems
Search this site:
I am frequently requested, by my work colleagues, to assist with Excel problems.
Over time, I have noticed that the same Excel errors and problems are repeatedly encountered, by different users.
Therefore, I have included the following table in this website, which describes a number of commonly encountered spreadsheet problems,
followed by methods of resolving these problems.
The table below gives a brief description of the most commonly encountered problems in Excel, categorised by the types of
built-in functions that they are frequently linked to.
Click on the links below to view further details and solutions.
Problems Linked to Date & Time Functions
Problems Linked to Lookup & Reference Functions
General Problems - Linked to Any Functions
|
Excel Won't Calculate My Function
- You enter your function into a cell and when you press return, the cell just shows your function, or the cell fails to update the function.
|