The solution is simple but will probably require your infrastructure folks.  Make a local (remote) file share with appropriate network login and rights.  Then, access the local share from...

You did the whole job (no mean feat), put your time aside to document the ins and outs, and placed your skill on display for all (pros and cons) to...

I have been discussing the WITH CUBE, CUBE() and Excel Pivot Table functionality with Microsoft's SQL Server and Excel Teams. Here is the highlights of the discussion to date:

WITH...

I reported the depreciation of the WITH CUBE functionality.

This is an interesting case that requires more investigation. Microsoft's Excel 2007 does not respect the NULL rows for subtotaling in...

Here is what I found out today from TechNet (Notice "the will be removed" language:

WITH CUBE

This feature will be removed in a future version of Microsoft SQL Server. Avoid...

Super explanation and it clarifies and identifies a simpler and faster approach to building crosstabs. My hat is tipped to you Jeff - Pick clarity of thought, writing ability...