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

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

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.