When you save a worksheet as a webpage it is no longer a real worksheet and
most Excel settings are lost. At the risk of stating the obvious, saving
each worksheet are its own workbook should fix these issues. If users do
not have Excel there is a viewer available from MS.

--
Jim
"pattyw" wrote in message
...
|I have a workbook with 70 worksheets that I need to share with 70 people.
| Each person is only to have access to one of the worksheets from the
| workbook. I am currently saving each of the 70 worksheets in my workbook
as
| a separte, non-interactive web page, in 70 seperate folders. When I do
this,
| I lose the page formatting in my worksheets. Each new webpage wants to
print
| as 4 pages instead of 1 as they do in my workbook. Is there any way to
copy
| the page formatting to the web pages, other than going into each of the 70
| web pages and reformatting? Or is there a better way for me to share all
of
| these worksheets, so that I will not lose my formatting? Any suggestions
| would be greatly appreciated. Thanks.
| --
| patty