Link to home
Start Free TrialLog in
Avatar of Steve Lowry
Steve LowryFlag for United States of America

asked on

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.
ASKER CERTIFIED SOLUTION
Avatar of James Murrell
James Murrell
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Steve Lowry

ASKER

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
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

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.
possible but i am afraid we cannot have everything....
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