Thanks for the info, I shall have a look at that and see if I can get
something working.

:)

For the expaanding and contracting stuff, it's basically a hierarchical set
of stats, and the client would like to be able to expand and contract the
different levels of stats. Again, this would have to be dynamic, as the data
would vary each time the report is run. The data is already formatted in a
hierarchical fashion in the spreadsheet (SQL Server does all of the work for
this and just drops the data into the spreadhseet). At the moment my line of
thinking is that this would have to be VBA code, as you suggest, that get's
run by the spreadsheet when it's opened....... Do you have any useful links
or pointers on how to do this, as it's not something I've had to do before!

Regards,

Tim.