Adjust size of Excel Web Page to fill the screen.

When I publish an entire Excel workbook as a web page, it fills about 3/4 of the screen with white space around it.  I cannot find a way to adjust the size of the web page.  I have Microsoft FrontPage available to make changes to the HTML code, but I do not know what to change to make the web page fill the screen.
Steve LowryPrincipal ChemistAsked:
Who is Participating?
 
James MurrellConnect With a Mentor Product SpecialistCommented:
if doing all in frontpage

look at line
<table width='100%' cellpadding='0' cellspacing='0' border='0' height='8'>

<html>
 
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 6.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>New Page 1</title>
<meta name="Microsoft Border" content="b, default">
</head>
 
<body>
 
<p>
<object classid="clsid:0002E559-0000-0000-C000-000000000046" id="Spreadsheet1" width="100%">
	<param name="DataType" value="XMLDATA">
	<param name="XMLData" value="&lt;?xml version=&quot;1.0&quot;?&gt;
&lt;ss:Workbook xmlns:x=&quot;urn:schemas-microsoft-com:office:excel&quot;
 xmlns:ss=&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;
 xmlns:c=&quot;urn:schemas-microsoft-com:office:component:spreadsheet&quot;&gt;
 &lt;x:ExcelWorkbook&gt;
  &lt;x:ProtectStructure&gt;False&lt;/x:ProtectStructure&gt;
  &lt;x:ActiveSheet&gt;0&lt;/x:ActiveSheet&gt;
 &lt;/x:ExcelWorkbook&gt;
 &lt;ss:Styles&gt;
  &lt;ss:Style ss:ID=&quot;Default&quot;&gt;
   &lt;ss:Alignment ss:Horizontal=&quot;Automatic&quot; ss:Rotate=&quot;0.0&quot; ss:Vertical=&quot;Bottom&quot;
    ss:ReadingOrder=&quot;Context&quot;/&gt;
   &lt;ss:Borders&gt;
   &lt;/ss:Borders&gt;
   &lt;ss:Font ss:FontName=&quot;Arial&quot; ss:Size=&quot;10&quot; ss:Color=&quot;Automatic&quot; ss:Bold=&quot;0&quot;
    ss:Italic=&quot;0&quot; ss:Underline=&quot;None&quot;/&gt;
   &lt;ss:Interior ss:Color=&quot;Automatic&quot; ss:Pattern=&quot;None&quot;/&gt;
   &lt;ss:NumberFormat ss:Format=&quot;General&quot;/&gt;
   &lt;ss:Protection ss:Protected=&quot;1&quot;/&gt;
  &lt;/ss:Style&gt;
 &lt;/ss:Styles&gt;
 &lt;c:ComponentOptions&gt;
  &lt;c:Label&gt;
   &lt;c:Caption&gt;Microsoft Office Spreadsheet&lt;/c:Caption&gt;
  &lt;/c:Label&gt;
  &lt;c:MaxHeight&gt;80%&lt;/c:MaxHeight&gt;
  &lt;c:MaxWidth&gt;80%&lt;/c:MaxWidth&gt;
  &lt;c:NextSheetNumber&gt;4&lt;/c:NextSheetNumber&gt;
 &lt;/c:ComponentOptions&gt;
 &lt;x:WorkbookOptions&gt;
  &lt;c:OWCVersion&gt;11.0.0.8166         &lt;/c:OWCVersion&gt;
  &lt;x:Height&gt;7620&lt;/x:Height&gt;
  &lt;x:Width&gt;18838&lt;/x:Width&gt;
 &lt;/x:WorkbookOptions&gt;
 &lt;ss:Worksheet ss:Name=&quot;Sheet1&quot;&gt;
  &lt;x:WorksheetOptions&gt;
   &lt;x:Selected/&gt;
   &lt;x:ViewableRange&gt;R1:R262144&lt;/x:ViewableRange&gt;
   &lt;x:Selection&gt;R1C1&lt;/x:Selection&gt;
   &lt;x:TopRowVisible&gt;0&lt;/x:TopRowVisible&gt;
   &lt;x:LeftColumnVisible&gt;0&lt;/x:LeftColumnVisible&gt;
   &lt;x:ProtectContents&gt;False&lt;/x:ProtectContents&gt;
  &lt;/x:WorksheetOptions&gt;
  &lt;c:WorksheetOptions&gt;
  &lt;/c:WorksheetOptions&gt;
 &lt;/ss:Worksheet&gt;
 &lt;ss:Worksheet ss:Name=&quot;Sheet2&quot;&gt;
  &lt;x:WorksheetOptions&gt;
   &lt;x:ViewableRange&gt;R1:R262144&lt;/x:ViewableRange&gt;
   &lt;x:Selection&gt;R1C1&lt;/x:Selection&gt;
   &lt;x:TopRowVisible&gt;0&lt;/x:TopRowVisible&gt;
   &lt;x:LeftColumnVisible&gt;0&lt;/x:LeftColumnVisible&gt;
   &lt;x:ProtectContents&gt;False&lt;/x:ProtectContents&gt;
  &lt;/x:WorksheetOptions&gt;
  &lt;c:WorksheetOptions&gt;
  &lt;/c:WorksheetOptions&gt;
 &lt;/ss:Worksheet&gt;
 &lt;ss:Worksheet ss:Name=&quot;Sheet3&quot;&gt;
  &lt;x:WorksheetOptions&gt;
   &lt;x:ViewableRange&gt;R1:R262144&lt;/x:ViewableRange&gt;
   &lt;x:Selection&gt;R1C1&lt;/x:Selection&gt;
   &lt;x:TopRowVisible&gt;0&lt;/x:TopRowVisible&gt;
   &lt;x:LeftColumnVisible&gt;0&lt;/x:LeftColumnVisible&gt;
   &lt;x:ProtectContents&gt;False&lt;/x:ProtectContents&gt;
  &lt;/x:WorksheetOptions&gt;
  &lt;c:WorksheetOptions&gt;
  &lt;/c:WorksheetOptions&gt;
 &lt;/ss:Worksheet&gt;
&lt;/ss:Workbook&gt;
">
	<param name="AllowPropertyToolbox" value="-1">
	<param name="AutoFit" value="0">
	<param name="Calculation" value="-4105">
	<param name="Caption" value="Microsoft Office Spreadsheet">
	<param name="DisplayColumnHeadings" value="-1">
	<param name="DisplayGridlines" value="-1">
	<param name="DisplayHorizontalScrollBar" value="-1">
	<param name="DisplayOfficeLogo" value="-1">
	<param name="DisplayPropertyToolbox" value="0">
	<param name="DisplayRowHeadings" value="-1">
	<param name="DisplayTitleBar" value="0">
	<param name="DisplayToolbar" value="-1">
	<param name="DisplayVerticalScrollBar" value="-1">
	<param name="DisplayWorkbookTabs" value="-1">
	<param name="EnableEvents" value="-1">
	<param name="MaxHeight" value="80%">
	<param name="MaxWidth" value="80%">
	<param name="MoveAfterReturn" value="-1">
	<param name="MoveAfterReturnDirection" value="-4121">
	<param name="RightToLeft" value="0">
	<param name="ScreenUpdating" value="-1">
	<param name="LockedDown" value="0">
	<param name="ConnectedToChart" value="0">
	<param name="DefaultQueryOnLoad" value="-1">
	<param name="EnableUndo" value="-1">
	<table width='100%' cellpadding='0' cellspacing='0' border='0' height='8'><tr><td bgColor='#336699' height='25' width='10%'>&nbsp;</td><td bgColor='#666666'width='85%'><font face='Tahoma' color='white' size='4'><b>&nbsp; Missing: Microsoft Office Web Components</b></font></td></tr><tr><td bgColor='#cccccc' width='15'>&nbsp;</td><td bgColor='#cccccc' width='500px'><br> <font face='Tahoma' size='2'>This page requires the Microsoft Office Web Components.<p align='center'> <a href='E:/files/owc11/setup.exe'>Click here to install Microsoft Office Web Components.</a>.</p></font><p><font face='Tahoma' size='2'>This page also requires Microsoft Internet Explorer 5.01 or higher.</p><p align='center'><a href='http://www.microsoft.com/windows/ie/default.htm'> Click here to install the latest Internet Explorer</a>.</font><br>&nbsp;</td></tr></table></object>
</p>
 
</body>
 
</html>

Open in new window

0
 
Steve LowryPrincipal ChemistAuthor Commented:
Thanks for your reply.  I pasted the statement you provided in the location designated and did not get the results I wanted.  I have attached a test workbook,  and a screenprint of what I see when I open the web page in my browser (my screen resolution is 1280 x 1024).  Also included is the code for the .htm file that is generated when the workbook is published as a web page.  I will be republishing the web page when I make changes to the workbook, so please note the statement in the code about information between the DIV tags being replaced when republished.

Thanks for your help.
Steve
<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
 
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=FrontPage.Editor.Document>
<meta name=Generator content="Microsoft Excel 11">
<link rel=File-List href="Pagetest_files/filelist.xml">
</head>
 
<body>
<!--[if !excel]>&nbsp;&nbsp;<![endif]-->
<!--The following information was generated by Microsoft Office Excel's Publish
as Web Page wizard.-->
<!--If the same item is republished from Excel, all information between the DIV
tags will be replaced.-->
<!----------------------------->
<!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD -->
<!----------------------------->
 
<div id="testbook_13424" align=center x:publishsource="Excel"><object
 id="testbook_13424_Spreadsheet"
 classid="CLSID:0002E559-0000-0000-C000-000000000046">
 <param name=DisplayTitleBar value=false>
 <param name=Autofit value=true>
 <param name=DataType value=XMLData>
 <param name=XMLData
 value="&lt;?xml version=&quot;1.0&quot;?&gt;&#13;&#10;&lt;?mso-application progid=&quot;Excel.Sheet&quot;?&gt;&#13;&#10;&lt;Workbook xmlns=&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;&#13;&#10; xmlns:o=&quot;urn:schemas-microsoft-com:office:office&quot;&#13;&#10; xmlns:x=&quot;urn:schemas-microsoft-com:office:excel&quot;&#13;&#10; xmlns:ss=&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;&#13;&#10; xmlns:html=&quot;http://www.w3.org/TR/REC-html40&quot;&gt;&#13;&#10; &lt;DocumentProperties xmlns=&quot;urn:schemas-microsoft-com:office:office&quot;&gt;&#13;&#10;  &lt;Author&gt; Chemical Company&lt;/Author&gt;&#13;&#10;  &lt;LastAuthor&gt; Chemical Company&lt;/LastAuthor&gt;&#13;&#10;  &lt;Created&gt;2008-10-14T14:31:34Z&lt;/Created&gt;&#13;&#10;  &lt;LastSaved&gt;2008-10-15T11:59:21Z&lt;/LastSaved&gt;&#13;&#10;  &lt;Company&gt; Chemical Company&lt;/Company&gt;&#13;&#10;  &lt;Version&gt;11.8132&lt;/Version&gt;&#13;&#10; &lt;/DocumentProperties&gt;&#13;&#10; &lt;OfficeDocumentSettings xmlns=&quot;urn:schemas-microsoft-com:office:office&quot;&gt;&#13;&#10;  &lt;RelyOnVML/&gt;&#13;&#10;  &lt;AllowPNG/&gt;&#13;&#10;  &lt;PixelsPerInch&gt;120&lt;/PixelsPerInch&gt;&#13;&#10;  &lt;TargetScreenSize&gt;1280x1024&lt;/TargetScreenSize&gt;&#13;&#10; &lt;/OfficeDocumentSettings&gt;&#13;&#10; &lt;ExcelWorkbook xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;&#13;&#10;  &lt;PublishObjects&gt;&#13;&#10;   &lt;PublishObject&gt;&#13;&#10;    &lt;Id&gt;13424&lt;/Id&gt;&#13;&#10;    &lt;DivID&gt;testbook_13424&lt;/DivID&gt;&#13;&#10;    &lt;SourceType&gt;SourceWorkbook&lt;/SourceType&gt;&#13;&#10;    &lt;HtmlType&gt;HtmlCalc&lt;/HtmlType&gt;&#13;&#10;    &lt;Location x:HRef=&quot;G:\Engineering\LAB\AB3 and Q1 Logs\Pagetest.htm&quot;/&gt;&#13;&#10;   &lt;/PublishObject&gt;&#13;&#10;   &lt;AutoRepublish&gt;&#13;&#10;    &lt;DivID&gt;testbook_13424&lt;/DivID&gt;&#13;&#10;   &lt;/AutoRepublish&gt;&#13;&#10;  &lt;/PublishObjects&gt;&#13;&#10;  &lt;WindowHeight&gt;13035&lt;/WindowHeight&gt;&#13;&#10;  &lt;WindowWidth&gt;14955&lt;/WindowWidth&gt;&#13;&#10;  &lt;WindowTopX&gt;720&lt;/WindowTopX&gt;&#13;&#10;  &lt;WindowTopY&gt;330&lt;/WindowTopY&gt;&#13;&#10;  &lt;ProtectStructure&gt;False&lt;/ProtectStructure&gt;&#13;&#10;  &lt;ProtectWindows&gt;False&lt;/ProtectWindows&gt;&#13;&#10; &lt;/ExcelWorkbook&gt;&#13;&#10; &lt;Styles&gt;&#13;&#10;  &lt;Style ss:ID=&quot;Default&quot; ss:Name=&quot;Normal&quot;&gt;&#13;&#10;   &lt;Alignment ss:Vertical=&quot;Bottom&quot;/&gt;&#13;&#10;   &lt;Borders/&gt;&#13;&#10;   &lt;Font/&gt;&#13;&#10;   &lt;Interior/&gt;&#13;&#10;   &lt;NumberFormat/&gt;&#13;&#10;   &lt;Protection/&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s22&quot;&gt;&#13;&#10;   &lt;Interior ss:Color=&quot;#FF6600&quot; ss:Pattern=&quot;Solid&quot;/&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10;  &lt;Style ss:ID=&quot;s23&quot;&gt;&#13;&#10;   &lt;Interior ss:Color=&quot;#FFFF00&quot; ss:Pattern=&quot;Solid&quot;/&gt;&#13;&#10;  &lt;/Style&gt;&#13;&#10; &lt;/Styles&gt;&#13;&#10; &lt;Worksheet ss:Name=&quot;Sheet1&quot;&gt;&#13;&#10;  &lt;Table ss:ExpandedColumnCount=&quot;3&quot; ss:ExpandedRowCount=&quot;21&quot; x:FullColumns=&quot;1&quot;&#13;&#10;   x:FullRows=&quot;1&quot;&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell&gt;&lt;Data ss:Type=&quot;String&quot;&gt;This is Sheet 1 of the test workbook.&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row ss:Index=&quot;4&quot;&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s22&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;  &lt;/Table&gt;&#13;&#10;  &lt;WorksheetOptions xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;&#13;&#10;   &lt;ProtectObjects&gt;False&lt;/ProtectObjects&gt;&#13;&#10;   &lt;ProtectScenarios&gt;False&lt;/ProtectScenarios&gt;&#13;&#10;  &lt;/WorksheetOptions&gt;&#13;&#10; &lt;/Worksheet&gt;&#13;&#10; &lt;Worksheet ss:Name=&quot;Sheet2&quot;&gt;&#13;&#10;  &lt;Table ss:ExpandedColumnCount=&quot;3&quot; ss:ExpandedRowCount=&quot;9&quot; x:FullColumns=&quot;1&quot;&#13;&#10;   x:FullRows=&quot;1&quot;&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell&gt;&lt;Data ss:Type=&quot;String&quot;&gt;This is Sheet 2 of the test workbook&lt;/Data&gt;&lt;/Cell&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row ss:Index=&quot;4&quot;&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;   &lt;Row&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;    &lt;Cell ss:StyleID=&quot;s23&quot;/&gt;&#13;&#10;   &lt;/Row&gt;&#13;&#10;  &lt;/Table&gt;&#13;&#10;  &lt;WorksheetOptions xmlns=&quot;urn:schemas-microsoft-com:office:excel&quot;&gt;&#13;&#10;   &lt;ProtectObjects&gt;False&lt;/ProtectObjects&gt;&#13;&#10;   &lt;ProtectScenarios&gt;False&lt;/ProtectScenarios&gt;&#13;&#10;  &lt;/WorksheetOptions&gt;&#13;&#10; &lt;/Worksheet&gt;&#13;&#10;&lt;/Workbook&gt;&#13;&#10;">
 <p style='margin-top:100;font-family:Arial;font-size:8.0pt'>To use this Web
 page interactively, you must have Microsoft® Internet Explorer 5.01 Service
 Pack 2 (SP2) or later and the Microsoft Office 2003 Web Components.</p>
 <p style='margin-top:100;font-family:Arial;font-size:8.0pt'>See the <a
 href="http://r.office.microsoft.com/r/rlidmsowcpub?clid=1033&amp;p1=Excel">Microsoft
 Office Web site</a> for more information.</p>
</object></div>
 
 
<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>
 
</html>

Open in new window

testbook.xls
Screenprint-of-Testbook-displaye.doc
0
 
James MurrellProduct SpecialistCommented:
thanks for this try

i changed

      <object
 id="testbook_13424_Spreadsheet"
 classid="CLSID:0002E559-0000-0000-C000-000000000046" width="100%" height="288">

<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">
 
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=FrontPage.Editor.Document>
<meta name=Generator content="Microsoft FrontPage 6.0">
</head>
 
<body>
<!--[if !excel]>  <![endif]-->
<!--The following information was generated by Microsoft Office Excel's Publish
as Web Page wizard.-->
<!--If the same item is republished from Excel, all information between the DIV
tags will be replaced.-->
<!----------------------------->
<!--START OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD -->
<!----------------------------->
 
<div id="testbook_13424" align=center x:publishsource="Excel">
	<object
 id="testbook_13424_Spreadsheet"
 classid="CLSID:0002E559-0000-0000-C000-000000000046" width="100%" height="288">
 <param name=DisplayTitleBar value=0>
 <param name=Autofit value=-1>
 <param name=DataType value=XMLDATA>
 <param name=XMLData
 value="&lt;?xml version=&quot;1.0&quot;?&gt;
&lt;?mso-application progid=&quot;Excel.Sheet&quot;?&gt;&lt;ss:Workbook
 xmlns:o=&quot;urn:schemas-microsoft-com:office:office&quot;
 xmlns:x=&quot;urn:schemas-microsoft-com:office:excel&quot;
 xmlns:ss=&quot;urn:schemas-microsoft-com:office:spreadsheet&quot;
 xmlns:c=&quot;urn:schemas-microsoft-com:office:component:spreadsheet&quot;
 xmlns:html=&quot;http://www.w3.org/TR/REC-html40&quot;&gt;
 &lt;x:ExcelWorkbook&gt;
  &lt;x:ProtectStructure&gt;False&lt;/x:ProtectStructure&gt;
  &lt;x:ActiveSheet&gt;0&lt;/x:ActiveSheet&gt;
 &lt;/x:ExcelWorkbook&gt;
 &lt;ss:Styles&gt;
  &lt;ss:Style ss:ID=&quot;Default&quot;&gt;
   &lt;ss:Alignment ss:Horizontal=&quot;Automatic&quot; ss:Rotate=&quot;0.0&quot; ss:Vertical=&quot;Bottom&quot;
    ss:ReadingOrder=&quot;Context&quot;/&gt;
   &lt;ss:Borders&gt;
   &lt;/ss:Borders&gt;
   &lt;ss:Font ss:FontName=&quot;Arial&quot; ss:Size=&quot;10&quot; ss:Color=&quot;Automatic&quot; ss:Bold=&quot;0&quot;
    ss:Italic=&quot;0&quot; ss:Underline=&quot;None&quot;/&gt;
   &lt;ss:Interior ss:Color=&quot;Automatic&quot; ss:Pattern=&quot;None&quot;/&gt;
   &lt;ss:NumberFormat ss:Format=&quot;General&quot;/&gt;
   &lt;ss:Protection ss:Protected=&quot;1&quot;/&gt;
  &lt;/ss:Style&gt;
  &lt;ss:Style ss:ID=&quot;wc03CF96A0&quot;&gt;
   &lt;ss:Alignment ss:Vertical=&quot;Bottom&quot;/&gt;
   &lt;ss:Font/&gt;
   &lt;ss:Interior ss:Color=&quot;#FF6600&quot; ss:Pattern=&quot;Solid&quot;/&gt;
  &lt;/ss:Style&gt;
  &lt;ss:Style ss:ID=&quot;wc03CFC4A8&quot;&gt;
   &lt;ss:Alignment ss:Vertical=&quot;Bottom&quot;/&gt;
   &lt;ss:Font/&gt;
   &lt;ss:Interior ss:Color=&quot;#FFFF00&quot; ss:Pattern=&quot;Solid&quot;/&gt;
  &lt;/ss:Style&gt;
 &lt;/ss:Styles&gt;
 &lt;c:ComponentOptions&gt;
  &lt;c:Label&gt;
   &lt;c:Caption&gt;Microsoft Office Spreadsheet&lt;/c:Caption&gt;
  &lt;/c:Label&gt;
  &lt;c:SpreadsheetAutoFit/&gt;
  &lt;c:MaxHeight&gt;80&lt;/c:MaxHeight&gt;
  &lt;c:MaxWidth&gt;100%&lt;/c:MaxWidth&gt;
  &lt;c:NextSheetNumber&gt;1&lt;/c:NextSheetNumber&gt;
 &lt;/c:ComponentOptions&gt;
 &lt;x:WorkbookOptions&gt;
  &lt;c:OWCVersion&gt;11.0.0.8166         &lt;/c:OWCVersion&gt;
  &lt;x:Height&gt;7620&lt;/x:Height&gt;
  &lt;x:Width&gt;15240&lt;/x:Width&gt;
 &lt;/x:WorkbookOptions&gt;
 &lt;ss:Worksheet ss:Name=&quot;Sheet1&quot;&gt;
  &lt;x:WorksheetOptions&gt;
   &lt;x:Selected/&gt;
   &lt;x:ViewableRange&gt;R1:R262144&lt;/x:ViewableRange&gt;
   &lt;x:Selection&gt;R1C1&lt;/x:Selection&gt;
   &lt;x:TopRowVisible&gt;0&lt;/x:TopRowVisible&gt;
   &lt;x:LeftColumnVisible&gt;0&lt;/x:LeftColumnVisible&gt;
   &lt;x:ProtectContents&gt;False&lt;/x:ProtectContents&gt;
  &lt;/x:WorksheetOptions&gt;
  &lt;c:WorksheetOptions&gt;
  &lt;/c:WorksheetOptions&gt;
  &lt;ss:Table ss:ExpandedColumnCount=&quot;3&quot; ss:ExpandedRowCount=&quot;21&quot;
   ss:DefaultColumnWidth=&quot;48.0&quot; ss:DefaultRowHeight=&quot;12.75&quot;&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell&gt;
     &lt;ss:Data ss:Type=&quot;String&quot;&gt;This is Sheet 1 of the test workbook.&lt;/ss:Data&gt;
    &lt;/ss:Cell&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row ss:Index=&quot;4&quot;&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CF96A0&quot;/&gt;
   &lt;/ss:Row&gt;
  &lt;/ss:Table&gt;
 &lt;/ss:Worksheet&gt;
 &lt;ss:Worksheet ss:Name=&quot;Sheet2&quot;&gt;
  &lt;x:WorksheetOptions&gt;
   &lt;x:ViewableRange&gt;R1:R262144&lt;/x:ViewableRange&gt;
   &lt;x:Selection&gt;R1C1&lt;/x:Selection&gt;
   &lt;x:TopRowVisible&gt;0&lt;/x:TopRowVisible&gt;
   &lt;x:LeftColumnVisible&gt;0&lt;/x:LeftColumnVisible&gt;
   &lt;x:ProtectContents&gt;False&lt;/x:ProtectContents&gt;
  &lt;/x:WorksheetOptions&gt;
  &lt;c:WorksheetOptions&gt;
  &lt;/c:WorksheetOptions&gt;
  &lt;ss:Table ss:ExpandedColumnCount=&quot;3&quot; ss:ExpandedRowCount=&quot;9&quot;
   ss:DefaultColumnWidth=&quot;48.0&quot; ss:DefaultRowHeight=&quot;12.75&quot;&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell&gt;
     &lt;ss:Data ss:Type=&quot;String&quot;&gt;This is Sheet 2 of the test workbook&lt;/ss:Data&gt;
    &lt;/ss:Cell&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row ss:Index=&quot;4&quot;&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
   &lt;/ss:Row&gt;
   &lt;ss:Row&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
    &lt;ss:Cell ss:StyleID=&quot;wc03CFC4A8&quot;/&gt;
   &lt;/ss:Row&gt;
  &lt;/ss:Table&gt;
 &lt;/ss:Worksheet&gt;
  &lt;o:DocumentProperties&gt;
   &lt;o:Author&gt; Chemical Company&lt;/o:Author&gt;
   &lt;o:LastAuthor&gt; Chemical Company&lt;/o:LastAuthor&gt;
   &lt;o:Created&gt;2008-10-14T14:31:34Z&lt;/o:Created&gt;
   &lt;o:LastSaved&gt;2008-10-15T11:59:21Z&lt;/o:LastSaved&gt;
   &lt;o:Company&gt; Chemical Company&lt;/o:Company&gt;
   &lt;o:Version&gt;11.8132&lt;/o:Version&gt;
  &lt;/o:DocumentProperties&gt;
  &lt;o:OfficeDocumentSettings&gt;
   &lt;o:RelyOnVML/&gt;
   &lt;o:AllowPNG/&gt;
   &lt;o:PixelsPerInch&gt;120&lt;/o:PixelsPerInch&gt;
   &lt;o:TargetScreenSize&gt;1280x1024&lt;/o:TargetScreenSize&gt;
  &lt;/o:OfficeDocumentSettings&gt;
&lt;/ss:Workbook&gt;
">
 <param name="AllowPropertyToolbox" value="-1">
	<param name="Calculation" value="-4105">
	<param name="Caption" value="Microsoft Office Spreadsheet">
	<param name="DisplayColumnHeadings" value="-1">
	<param name="DisplayGridlines" value="-1">
	<param name="DisplayHorizontalScrollBar" value="-1">
	<param name="DisplayOfficeLogo" value="-1">
	<param name="DisplayPropertyToolbox" value="0">
	<param name="DisplayRowHeadings" value="-1">
	<param name="DisplayToolbar" value="-1">
	<param name="DisplayVerticalScrollBar" value="-1">
	<param name="DisplayWorkbookTabs" value="-1">
	<param name="EnableEvents" value="-1">
	<param name="MaxHeight" value="80">
	<param name="MaxWidth" value="100%">
	<param name="MoveAfterReturn" value="-1">
	<param name="MoveAfterReturnDirection" value="-4121">
	<param name="RightToLeft" value="0">
	<param name="ScreenUpdating" value="-1">
	<param name="LockedDown" value="0">
	<param name="ConnectedToChart" value="0">
	<param name="DefaultQueryOnLoad" value="-1">
	<param name="EnableUndo" value="-1">
<p style='margin-top:100;font-family:Arial;font-size:8.0pt'>To use this Web
 page interactively, you must have Microsoft® Internet Explorer 5.01 Service
 Pack 2 (SP2) or later and the Microsoft Office 2003 Web Components.</p>
 <p style='margin-top:100;font-family:Arial;font-size:8.0pt'>See the <a
 href="http://r.office.microsoft.com/r/rlidmsowcpub?clid=1033&amp;p1=Excel">Microsoft
 Office Web site</a> for more information.</p>
</object></div>
 
 
<!----------------------------->
<!--END OF OUTPUT FROM EXCEL PUBLISH AS WEB PAGE WIZARD-->
<!----------------------------->
</body>
 
</html>

Open in new window

0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Steve LowryPrincipal ChemistAuthor Commented:
The change did make the web page wider, but it has very little height.  I have tried to change the height value, but it has not made a difference.
Also, with the width and height statement located between the DIVs, won't I lose that formatting when I republish the web page?

Thanks.
0
 
James MurrellProduct SpecialistCommented:
possible but i am afraid we cannot have everything....
0
 
Steve LowryPrincipal ChemistAuthor Commented:
The more I look into this issue, it looks like I am going to get what I am going to get.  Even though I would like more control, I can live with the formatting as it is.

I really appreciate your time in looking at this.

Thanks.
Steve
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.