View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
bunt.[_2_] bunt.[_2_] is offline
external usenet poster
 
Posts: 3
Default Interactive excel web page resizable?

Sorry those '<' symbols should be 'And' symbols.. for some reason it doesnt
work on this forum

"bunt." wrote:

Hi,
I'm not very skilled in the area of excel or .html, although I've been just
recently trying to do the same thing. I found a way to resize the table as
you asked. Here's the step by step:

1. Save your exel file as a webpage somewhere that it can be easily
accessed, like your desktop.

2. Right click on the file you just saved and choose 'Open With' then 'Note
Pad'.

3. Note pad will open up with loads of .html source code. Click 'Format' at
the top of the window, then 'Word Wrap' if it isn't already checked. (This
should ensure that there is only one scroll bar accessible in the window, and
it should be on the right).

4. Scroll down about 1/8th of the way down the page. Keep an eye on the
left most symbols. They should eventually change to a series of "<" symbols
then "style=" symbols. Stop here.

5. Within that code a little to the right look for '<x:MaxHeight 80%' and
just below on the next line '<x:MaxWidth; 80%'. Now change those 80's to 100
and click 'file' then 'save'.

6. Reopen the .html saved version on your desktop, this time with iexplorer.

That should help a bit anyway. This is my at home/no previouse experience
method. I keep toying with this code because I want to permanently get rid
of the tool bars and cell lines. If you figure it out let me know.

"DieHardAstrosFan" wrote:

Is there a way to make an interactive excel web page resizable with the IE
window? I'm trying to use the save as webpage functionality in Excel 2003 to
create an interactive excel spreadsheet for my users through IE; however, the
embedded excel box doesn't take up enough space in the browser and the user
is stuck messing with scroll bars. Is there a way to make the excel
spreadsheet bigger on the page?