Publishing Your Worksheet To The Internet

Publishing your worksheet on the Internet makes it readily available to anyone who has Internet access.  By publishing it on a password protected Web site the Internet becomes a secure and timely method to distribute information.  In this example we will publish the worksheet we just created on a secure web site.  To be able to do this, you will have to have access to a Web server.

The following are the steps to follow: 

•      Select Save As Web Page from the File menu.
•      Select Publish from the Save As menu.
•      Click on the Browse button and identify the web site. It
       is important that you do not click on the Add interactivity
       with: check box.  Adding interactivity will cause the
       AutoShape and the e-mail link not to work.
•      Click on OK and you are done.

 

 

 

 

 

Excel Worksheet Published as a Web Page

You can save a Microsoft Excel workbook or part of the workbook, such as a single item on the worksheet, as a Web page and make it available on an HTTP. Just like normal web pages, readers will be able to access this web page to retrieve text, graphics, sound, and other digital information from a Web server. You can publish interactive or non-interactive versions of your entire workbook as a Web page.

 

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 the following functionality works: 

• Worksheets
• PivotTable reports
• External data ranges- data that is brought into a worksheet that originates outside of Excel.
• Ranges of cells
• Filtered lists
• Print areas
• Charts

You can publish a chart with or without interactivity. When you publish without interactivity, an image of the chart in a picture format (.jpg) is saved and displayed on the Web page. If you want to put an interactive chart or PivotChart report on a Web page, you can save the chart with interactive chart functionality. Thereafter, when you change the chart's corresponding data on the Web page, the chart is updated automatically. 

To create a chart with interactive functionality, you must first have a chart or a PivotChart report in Excel. When you publish that chart interactively, Excel automatically includes the source data for the chart on the Web page. If you want to change the size of the chart on the Web page, you can open the Web page in either Microsoft FrontPage or Data Access Page Design view in Microsoft Access and make the changes there.

You can publish a PivotTable Report with or without interactivity. When you publish without interactivity, users can view the report but cannot make changes to the table such as dragging fields or changing the types of summaries used, as can be done in Excel. If you want your Web users to be able to interact with a PivotTable report or if you want to publish an external data range  that you can refresh, you can put an interactive PivotTable list on a Web page. (The Web version of an interactive PivotTable report is called a PivotTable list.) When you publish interactively with PivotTable functionality, users can filter the data in the resulting PivotTable list, analyze the data by getting different views of it, and refresh external data in the browser.

Most Web pages that you create will contain more than one item. For example, you might have a Web page that contains your logo, text, a PivotTable list, a list of non-interactive data, and a chart. The advantage of putting several items on a single page is that users need to look on only one Web page for all of the information they need. You can make parts of your Web page interactive and other parts non-interactive. You can use features from several Microsoft Office programs to create one Web page. For example, you can save data as a Web page in Excel and then use Microsoft Access to add grouped data page controls or scripting. Then, you can open the Web page in Microsoft FrontPage and add themes to make your Web page look consistent with other pages in your site. Show below are a few web examples:

          

 

                 Tabbed Sheets                             Input Data                                             Pivot Chart

 

 

 

 

                                             Pivot Table                                         With Graphic Images

- END -