Create interactive web page in Excel

Create interactive web page in Excel: 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 as shown in the following Excel video, 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: An interactive, crosstabulated Excel report that summarizes and analyzes data, such as database records, from various sources, including ones that are external to Excel.
External data ranges: A range of data that is brought into a worksheet but that originates outside of Excel, such as in a database or text file. In Excel, you can format the data or use it in calculations as you would any other data.
Ranges of cells
Filtered lists
Print areas
You might lose some formatting and features when you save with interactive functionality.
Our example shows how you can share a loan calculator as web page!