You can publish a spreadsheet or portions of a spreadsheet on a Web page either with or without interactive functionality.
When you publish without interactivity, users can view the data and formatting on the Web page, but not manipulate data or formatting.
If you want users to be able to manipulate data on your Web page, you can create a Web page from a Microsoft Excel worksheet or items from the worksheet by saving the data with spreadsheet functionality. When you publish interactively with spreadsheet functionality, users can do the following:
• Enter data
• Format data
• Calculate data
• Analyze data
• Sort and filter
In interactive Web pages, users can change the data and layout of Web page items.
You can put the following on a Web page with spreadsheet functionality:
• PivotTable reports
• External data ranges
• Ranges of cells
• Filtered lists
• Print areas
You might lose some formatting and features when you save with interactive functionality.
When you use the SAVE AS... option from the FILE menu, the dialog window that appears will have a check box for setting "Add interactivity".