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?

On Jul 3, 10:58 pm, 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?

I don't think the Excel web spreadsheet can be resized in the window.
It seems to size itself based on the IE window size (less a margin all
round). I have made the IE window as large as possible by stretching
it to the edges of my screen, (not by maximising), then closing it so
the size gets saved. Then, I create the web page from Excel. This
technique seems to give the biggest area. Your mileage may vary. It
maybe possible to adjust some parameters in the actual HTML page it
creates but I get lost every time I look at the source :-)

David

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?

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?