If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel Worksheets
Does anyone here know how to make a Excel Document display
properly on a web page. When I try it, all I get is a little box, with a X in it. I would appreciate any help |
#2
|
|||
|
|||
Excel Worksheets
Richard
I suspect the description you have given may be a little vague for an answer. Perhaps you may be able to elaborate on what you have done to save it as HTML and where it is saved to, etc -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Richard" wrote in message ... Does anyone here know how to make a Excel Document display properly on a web page. When I try it, all I get is a little box, with a X in it. I would appreciate any help |
#3
|
|||
|
|||
Excel Worksheets
Hi Richard,
Put Excel data on a Web page Open or select the workbook that contains the items you want to publish. On the File menu, click Save as Web Page. If you have already selected the item you want to publish, or want to publish an entire workbook without interactivity, you can select the options you want in the Save as Web Page dialog box, click Save, and you're done. Otherwise, continue with the steps listed below. Click Publish. Under Item to publish, click what you want to publish in the Choose box. Choosing items to publish To select the worksheet or item that you want to publish, select one item from the Choose list. You can publish only one item at a time. To publish another item, select the new item and repeat the publishing procedure. The following list outlines what you can publish and how to publish it. Entire workbooks Select Entire workbook. You can publish an entire workbook with interactivity in the Publish dialog box, but not without interactivity. Entire worksheets Select Items on Sheetname, and then select All contents of Sheetname. Items Select Items on Sheetname, and then select the item you want to publish, such as a PivotTable report (PivotTable report: An interactive, crosstabulated Excel report that summarizes and analyzes data, such as database records, from various sources, including ones that are external to Excel.) or a chart. Items do not include ranges of cells. Ranges of cells Select Range of cells and then, if the selection box does not contain the range you want, click the worksheet (the dialog box will collapse to a selection box), select a range of cells from the Microsoft Excel workbook, and then click Expand Dialog . Charts Select Items on Sheetname, and then select Chart x. Filtered ranges Select Items on Sheetname, and then select the AutoFilter item you want to publish. External data ranges Select Items on Sheetname, and then select the Query item you want to publish. Republishing To republish a worksheet or item that you have already published, select Previously published items and then select the worksheet or item you want to republish. To prevent an item from being republished, select the item and click Remove. To continue publishing, click another item in the list. Under Viewing options, select or clear the Add interactivity with check box, and if necessary, click the type of functionality you want. Publishing with or without interactivity Publishing without interactivity If you want users to view the data you publish but not work with it in the browser, you can publish it as noninteractive data. You can open, edit and save noninteractive Web pages in Microsoft Excel, but you cannot make any changes to the data in the browser. Be sure the Add interactivity with check box under Viewing options is cleared. For a filtered range, Web page viewers can see only the data that was not filtered when you published the range. However, all data in the range is published to the Web page. Filtered (hidden) data can be viewed by viewing the HTML (HTML: The standard markup language used for documents on the World Wide Web. HTML uses tags to indicate how Web browsers should display page elements such as text and graphics and how to respond to user actions.) source code for the page. You cannot publish an entire workbook without interactivity in the Publish dialog box. Instead, click Save As Web Page on the File menu, and instead of clicking Publish, select Entire Workbook in the Save as Web Page dialog box and make sure the Add interactivity box is cleared. Publishing with interactivity To enable people to work with the data on your Web page in a browser, you can make your data interactive. For example, you can publish an interactive spreadsheet that calculates loan information. A user who browses to the page can enter financial information such as loan amount and interest rate to calculate a monthly payment. Select the Add interactivity with check box and select the type of interactivity you want from the list. The type of interactivity that's available depends on what you are publishing. For example: For a worksheet that contains formulas, select Spreadsheet functionality so that users of your Web page can enter new values in a cell and the formulas will automatically calculate the results. For a PivotTable report (PivotTable report: An interactive, crosstabulated Excel report that summarizes and analyzes data, such as database records, from various sources, including ones that are external to Excel.), select PivotTable functionality so that users of your Web page can change the layout of rows and columns to see different summaries of the source data. For an external data range (external data range: 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.), select PivotTable functionality so that Web page viewers can update the data from its source. For a filtered range, select Spreadsheet functionality. For a chart or PivotChart report (PivotChart report: A chart that provides interactive analysis of data, like a PivotTable report. You can change views of data, see different levels of detail, or reorganize the chart layout by dragging fields and by showing or hiding items in fields.), select Chart functionality. If you try to publish all contents of a worksheet that contains a chart with interactive functionality, the chart is not included on the Web page. To put an interactive chart on a Web page, you must publish the chart separately. Notes Browser users must have Microsoft Internet Explorer 4.1 or later and an appropriate Microsoft Office license to work with spreadsheets, charts, or PivotTable lists (PivotTable list: A Microsoft Office Web Component that allows you to create a structure similar to an Excel PivotTable report. Users can view the PivotTable list in a Web browser and change its layout in a manner similar to an Excel PivotTable report.) published interactively from Microsoft Excel. You cannot open and modify interactive Web pages in Excel, so it's a good idea to save a copy of the original workbook from which you publish in case you want to make changes in Excel and republish. To add a title over the published selection, click Change under Publish as. Type the title you want, and then click OK. Next to the File name box, click Browse, and locate the drive, folder, Web folder (Web folder: A shortcut you use to save, open, copy, or delete files on a Web or FTP server. Some Web folders, such as document libraries, have functionality not available with local folders. You'll find Web folders in My Network Places or Web Folders.), Web server (Web server: A computer that hosts Web pages and responds to requests from browsers. Also known as an HTTP server, a Web server stores files whose URLs begin with http://.), or FTP (FTP: A communication protocol that makes it possible for a user to transfer files between remote locations on a network. This protocol also allows users to use FTP commands, such as listing files and folders, to work with files on a remote location.) location where you want to save or publish your Web page. You can also choose an existing Web page to append to or replace as long as you have permission to modify the Web page and have access to the HTML (HTML: The standard markup language used for documents on the World Wide Web. HTML uses tags to indicate how Web browsers should display page elements such as text and graphics and how to respond to user actions.) file. To view the Web page in your browser after you publish it, select the Open published Web page in browser check box. If you expect to make changes in the workbook later and want to automatically republish the items each time the workbook is saved, select the AutoRepublish every time this workbook is saved check box. Click Publish. If you are publishing to an existing Web page, click Replace file to copy over the existing page, or Add to file to append your data to the end of the Web page. For Furhter Assistance: http://office.microsoft.com/assistan...052561501033&C TT=4&Origin=CH062528411033 Please let me know has this helped You... Thank you... Raghu... This posting is provided "AS IS" with no warranties, and confers no rights. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Macro help please: Excel data to word doc | anna-maria | General Discussion | 5 | June 30th, 2004 11:53 PM |
Opening excel 2000 worksheets in office 97 | Ni! | General Discussion | 2 | June 23rd, 2004 04:30 PM |
Coverting Lotus 123 files to use with excel | Muffin1947 | General Discussion | 6 | June 20th, 2004 10:18 AM |
Ctrl+A macro fix for problem in Excel 2003 | David McRitchie | General Discussion | 4 | June 19th, 2004 12:01 PM |
Error opening an excel file from explorer | Wah | Setting up and Configuration | 3 | February 17th, 2004 03:28 PM |