I like the way pivot makes its reports, collect/ manipulate data by CUBE Function.
1. Now because of this feature, can I use excel as a database?
2. How do I manage the database if there are many users who shares information and updates the same tables?
3. How do I protect the data from accidental deletion, corruption, etc.
4. The problem I also see is the GUI interface. It's kind of tedious inputing data on a spreadsheet. What will I do to make inputing more easy?
I appreciate your help.