Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word

8.3. Why You Need Parameters to Make Your Excel Form Interactive

Providing a static spreadsheet for users to view in the browser may have its place, but overall, most users want to change data in a spreadsheet, re-sort the data, or even filter the data to better serve their needs. After all, spreadsheets are all about what-if analysis and making business decisions after evaluating data.

While you cannot provide total access to all the features users might normally use directly within Excel, you can at least provide users with the option to change values associated with specific cells while viewing the spreadsheet. Besides, if they really need to have total control over the design of the spreadsheet and change the formatting, structure, or even ...