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.
The templates designed to use for saving calculations varies according to the saving calculations made depending on the types of calculations to be made. These spreadsheets make the calculations and the data entry easier than doing it by any other format.
When VisiCalc hit the scene back in the eighties (in the last century), the relatively small group of Apple II users went crazy. It was like manna from heaven for the poor accountants, scientists and engineers who were used to filling in enormous analysis sheets with a pencil. Now, they could use VisiCalc to do the same task, AND calculate the result automatically.
For pure data analysis, the spreadsheet is, indeed, king. To a point...Despite all of these extremely powerful features, the spreadsheet has limitations, which tend to manifest when you least expect it. Often, Murphy's Law applies and the spreadsheet falls over when you are right in the middle of a major undertaking, like month-end or meeting a tight deadline.