Excel to web

[ctopher06]

I'm not clear what needs to be donr for this. I have an Excel spreadsheet that has locked cells, web site links and is password protected. When I save as a web page, the formatting is changed and it does not show the full page. It is shown in a smaller window within IE. What am I missing? thanks

Chris

 

[maxamis4]

You might want to try forcing the link to open the excel spreadsheet in a new window.

 

[ctopher06]

Sorry away from this project so long.
I am still having problems getting an Excel spreadsheet to display as a web page correctly. I want it to fill the web page. Microsoft help has been no help.
Any suggestions are appreciated.

Chris

 

[firefytr]

Chris, filling a browser window doesn't have anything to do with Excel almost. If you want it to look bigger, you must make the font bigger. Right now it's really hard to judge what it is you actually want as you are not very descriptive at all.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[ctopher06]

Zack,
When I "Save as Web Page" from Excel, then open in IE, this is what I get.

http://i2.tinypic.com/23vjg52.jpg

I would like to have it fill the IE window.
Am I missing a step? Or is there another way to do this?
Thanks.

Chris

 

[firefytr]

When it [Excel] saves a web page, it should be the same size, meaning it will create the size on it's own. Whether it fits a browser or not is not up to Excel, but the browser. If you really wanted to, you could go in and edit the files Excel creates when you published as a web page, but you'd be into HTML then. If so, what you would be looking for is the table size as a set number of pixels, that would need to be changed to 100% of the [browser] instance.

Example:

width:"640"

.. would become ...

width:100%

These are just examples, but you really need to know HTML to know what you're looking at. Changing the table width could change how everything else looks. Please keep this in mind if editing any code.

HTH

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci

 

[ctopher06]

Thanks Zack. I tried changing the width, but no go.
Also when saving as web page, it will not take the sheet protection and jpg's are deleted.
I guess I will have to recreate the form as html.
Thanks for your help.

Chris

 

[firefytr]

For more functionality, that's probably best. The saveas webpage can get you started in the right direction. It's easiest to have some form of HTML editor to do this with, such as FrontPage or DreamWeaver. Good luck.

Regards,
Zack Barresse

Simplicity is the ultimate sophistication. What is a MS MVP? PODA
- Leonardo da Vinci