To "Excel" or not to "Excel"?

[SQLUser]

Hi,

Can anyone tell me where Excel lacks as an OLAP reporting tool? What are the major show-stoppers?

I know for sure that Excel is very popular among users and requires minimal training. I have a project coming up and I'm contemplating on using Excel.


Thanks!
X-)

[sig][/sig]

 

[nickdaniels]

Doesn't Excel have a limitation on the number of rows it can cope with. I know it used to be 16,000 ish and now its maybe 64,000 ish? [sig]<p> Nick<br><a href=mailto:ndaniels@ventura-uk.com>ndaniels@ventura-uk.com</a><br><a href= > </a><br>If it's Data Warehousing or related then I want to know - but post it to the forum![/sig]

 

[nickdaniels]

In fact the limits are 65,536 rows by 256 columns - it all depends on the volume and depth of information you are dealing with [sig]<p> Nick<br><a href=mailto:ndaniels@ventura-uk.com>ndaniels@ventura-uk.com</a><br><a href= > </a><br>If it's Data Warehousing or related then I want to know - but post it to the forum![/sig]