Saving Excel 2010 files as web page or single file web page

[Joe Artis]

I don't seem to be able to save Excel 2010 files as web or single file web
pages. A dialogue box with the following appears:

"Book1.xlsx may contain features that are not compatible with Web (or Single
file) Page. Do you want to keep the workbook in this format?

To keep this format, which leaves out any incompatible features, click Yes.

To preserve the features, click No. Then save a copy in the latest Excel
format.

To see what might be lost, click Help."

Using Excel 2000 and 2003 I can save Excel files as web pages then upload to
my website. Any suggestions?

Thank you.

 

[Mike Middleton]

Joe -

What happens when you click Yes?

I was able to save as a web page (although graphic objects on the worksheet
that save fine in Excel 2003 were somewhat messed up when saved with Excel
2010 Beta).

Since Excel 2010 is a beta version, it's useful to post the specific
version. I'm using 14.0.4536.1000.

- Mike
http://www.MikeMiddleton.com



I don't seem to be able to save Excel 2010 files as web or single file web
pages. A dialogue box with the following appears:

"Book1.xlsx may contain features that are not compatible with Web (or Single
file) Page. Do you want to keep the workbook in this format?

To keep this format, which leaves out any incompatible features, click Yes.

To preserve the features, click No. Then save a copy in the latest Excel
format.

To see what might be lost, click Help."

Using Excel 2000 and 2003 I can save Excel files as web pages then upload to
my website. Any suggestions?

Thank you.

 

[Steven Brock]

This works for me for Excel 2010
Select "File"
Select "Save As"
Select "Web Page (*.htm;*.html)" [Do Not Use - "Single File Web Page (*.mht;*mhtml)"]
Select radial button next to "Entire Workbook"
Select "Publish"
Using drop down select sheet you want to publish
OR "Remove" Sheets that you do not want to publish by highlighting
the sheets you do not want and selecting "Remove"
Select "Browse" and select the destination directory of the file
Select "Save as type" as "Web Page (*.htm;*.html)" [Do Not Use - "Single File Web Page (*.mht;*mhtml)"]
Name file using the extension ".html"
Select "Ok"
Select "Publish"
You should now see the html file in your destination directory