Excel Reporting via SharePoint

There are many ways to get your excel reports out to your branches.

One way is to upload them from excel or use some .net or vba code to pump them out from Excel to your Extranet.
The other way is to use Reporting Services and save the report as excel (if using reporting services 2008).
There is a trick to make the tabs look okay though rather than saying sheet 1, sheet 2 etc.

It's funny though that once you start doing this, then you need to script out the creation of the Extranet to make it easy to set permissions and manage.

This is where many people get it wrong because of their lack of experience and knowledge of SharePoint and the end result is an unmanageable Extranet.

We even built an Excel application just for building an extranet.
One fills in all the details, sets up the site template and hey presto a simple script that rolls out an extranet with no pain!

Regards,

Tom Bizannes