• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Lesson 20. Saving and Publishing Files t... > Static Versus Interactive Data

Static Versus Interactive Data

As you learned at the very beginning of this lesson, you can save your Excel data as static Web information or you can make it interactive, allowing users on the Web to input their own data and take advantage of the formulas and functions you have placed in the worksheet. If you want to place a snapshot of data, such as a quarterly report, onto the Web, you will want to publish static data. If you refer to Figure 20.3, you will notice that static data is the default.

To publish interactive data, where the information in the worksheet can be changed by a user viewing the worksheet using a Web browser, click the Add Interactivity With check box on the Publish as Web Page dialog box. Also, be sure that the drop-down list next to the check box displays Spreadsheet Functionality, which allows users to enter, update, copy, move, delete, format, sort, or filter data in a Web browser window (you will look at an interactive worksheet in a Web browser later in this lesson).


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint