Hi,

Maybe it's a marvelous idea, but......

Why do we need this ?

An Excel-user can create a Microsoft Query in Excel (OLEDB) and update the spreadsheet he created with all the formatting he wants.

The DBA creates a view for this purpose and give permission to the user who needs it.

Users can than select a subset of the data (if needed) by using parameters in the query.

Users are able to choose for automated refreshing of the data when openening their excel-spreadsheet or by command.

My experience is that when you build something specific for a user (formatting he wants, data he wants now), you will get a lot of requests for enhancements and little changements, which will keep you busy.

Regards,

Frank van de Ven