Size limitation : When a spreadsheet is first constructed and tested, the size tends to be small. However, as the spreadsheet grows with more and more data, it start slowing down, until it reaches that point where your feet go to sleep while you waiting for the re-calculation to finish.
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.
At present, some of the most requested types of spreadsheet packages in the market are: 'Spreadsheets for Small Businesses' and a subset of that: 'Spreadsheets for Actors'.
Many spreadsheet applications nowadays have functionality above and beyond the traditional, offering a variety of charts, look-up tables, databases and more functionality than can be mentioned here.
spreadsheet templates for small business
what is a spreadsheet used for