One user at a time : In the instance where there are a number of people required to work on a spreadsheet, they can only access it when no-one else is working on it.
Financial templates are highly complex and they deal with very large and advanced calculations. These spreadsheets are used in mortgage, loans, and property investments and so on.
Inconsistent data : This becomes most apparent when trying to find a particular record or cell, based on the contents. If a space is incorrectly added in the wrong place, the search or filter fails.
Protection of formulae : How often have you forgotten to protect the cell contains the formula that took you hours to test and perfect. It takes one instance of honest human error, and that formula is gone.
types of spreadsheet
spreadsheet templates for business
excel inventory templates