In too many cases people misuse Excel and they are not even close to realize that. From beginners euphoria about Excel as ultimate tool they end up drowning in Excel hell. At this point they blame Excel for everything: working too hard, loosing themselves, giving the wrong figures – or even worst several different but correct figures… After some time they do not know who to trust and as instinct command they start looking who to blame for their situation.
Let’s face the ultimate truth: Excel cannot be good or bad, only the way you use it can be good or bad.
I believe evolution of every office user starts with Word, after some time user move to Excel, after even more time they (may) move to Access… but they do not do that. They are simply stack at Excel forever. Why is it like that? Do you know that the cheapest MS Office package with Access costs much more money than package without it?
When Excel 2007 broke limit of cca 65000 row per sheet, everybody welcomed it with the same euphoria as described at the beginning of this post. I was quite depressed. I really hoped that people would outgrow Excel, because of that limit at least.
Handling sheet with more rows/columns then can be seen at one screen (without scrolling) is misuse of Excel. For everything more you should move to Access.
You may also choose to the best thing for you and implement business intelligence using MSSQL and Analyses Services.
Look for more details on this site.
