If your worksheet has several pages, it will be useful to have the header row repeat in all the pages. This will improve productivity as the user need not flip to the first page to view the header row columns.

Using Sharepoint Designer one can create a custom data view that can get data from several sources such as web services, xml data, database queries, and Sharepoint Lists. The view populates the data in real time and hence can be made available to the user's as a web page. This article outlines the method of creating a data view from a SP List.

If you have a macro enabled worksheet and would like the user to have the option to refresh data as required, have a macro button in the worksheet to initiate refresh of the data.. This article is for Excel 2007. If you are interested for Excel 2003. click here