Custom Search
|
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. |
Custom Search
|