saving as html makes spreadsheet too small when opened as web page 1

[toefuzzies]

In Office 2003 when I save a spreadsheet as a an .html file the spreadsheet appears larger on the .html page and causes users to have to scroll up and down to view the whole spreadsheet. Very "user-unfriendly"!

Is there a way to save the excel file so that when opened in IE Explorer it looks the same?

It's almost like when the worksheet is saved, and then opened in the .html file it is only given 3/4 of the page to open in. Like it's in some sort of a html frame or something...

Anyone else experienced this or know a way around this?

 

[straybullet]

Never noticed this before, so I decided to do a test run.

When saved as HTML with interactivity, there was a <div> created - the worksheet information is within this. Naturally, this limited the worksheet information to the smaller area - complete with frame-like scrollbars.

When saved as HTML with no interactivity, there was no <div> created and the worksheet information filled the page as expected.

Unless needed, I guess uncheck the interactivity box when "saving as". Perhaps one of the HTML gurus can assist with a way of setting the height/width parameters of the <div>

Let them hate - so long as they fear... Lucius Accius

 

[toefuzzies]

I think that is it. Someone else had also protected this file w/ a password and Excel was not allowing it to be published as a web page. I had not caught that earlier. I tried it myself and it works when the password is not set. Kind of weird, but I believe a solution was found nonetheless. Thanks again.