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

Chapter 6. Exhanging Data Annoyances > DATA FORMAT ANNOYANCES

DATA FORMAT ANNOYANCES

PLACE EXCEL DATA ON THE WEB

The Annoyance:

My boss wants our department's monthly figures to be available both in Excel and on a web page on the company intranet. It needs to be in both formats because we email the Excel file to outside vendors who cannot access the intranet. Each month I copy the data from Excel and paste it into a web editor to create a web page. This takes a while, and sometimes the information ends up in the wrong place. Is there some way I can just copy the whole worksheet to the web page?

The Fix:

In Excel 2000 and later, you can put Excel data on the Web simply by choosing File → Save as Web Page. Selecting this option displays the Save As dialog box with a few extra features for optimizing the Excel data to be used on the Web (shown in Figure 6-22). An option in the dialog is to save either the workbook or the current selection. The current selection can be the active sheet, or a selected worksheet area or range.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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