Web page options

Use the Web Page options dialog box to control various features and settings for Web pages that you save from or import to Microsoft Office Excel.

General tab

Save any additional hidden data necessary to maintain formulas      Select this check box to keep externally referenced data of formulas that are not in the selected range to be published, which increases the size of the file. This is the default. Clear this check box to not keep externally referenced data, to replace the formulas with calculated values, and to reduce the size of the file.

Note: This option only applies to interactive Web pages that use Office Web Components, which are being discontinued in Microsoft Office Excel 2007.

Load pictures from Web pages not created in Excel     Select this check box to load pictures that were created in other programs. This is the default. Clear this check box to ignore pictures that were created in other programs.

Browsers tab

Target Browsers section

People who view this Web Page will be using     Select the earliest version of the browser that you are targeting for display. The default is Internet Explorer 4.0.

Options section

Allow PNG as a graphics format     Select this check box to enable the Portable Network Graphics (PNG) graphic format. Clear this check box to disable the PNG graphic format. This is the default.

Rely on CSS     Select this check box to use cascading style sheets (CSS). This is the default. Clear this check box to not use cascading style sheets (CSS) because your target browser does not support them.

Rely on VML for displaying graphics in browsers     Select this check box to use Vector Markup Language (VML) to display graphics in your browser, which can speed up the downloading of Web pages. Clear this check box to not use VML, because your targeted browser does not support VML. This is the default.

Save new Web pages as Single File Web Pages    Select this check box to save files as Single File Web Pages (.mht, .mhtml) with content from supporting files — such as bullets, background textures, and graphics embedded in the Web page. This is the default. Clear this check box to save as a Web page with supporting files. Use this option if you have added the Save As Web Page command to the Quick Access Toolbar.

Files tab

File names and locations section

Organize supporting files in a folder     Select this check box to store all supporting files — such as bullets, background textures, and graphics — in a separate subfolder. This is the default. Clear this check box to save supporting files in the same folder as the Web page.

Use long file names whenever possible     Select this check box to use a long file name (a file name with spaces or more than eight characters) because they are supported on the Web server. This is the default. Clear this check box to use short file names (8.3 notation) because long names are not supported on the Web server.

Update links on save     Select this check box to not move or copy the supporting files when you move or copy a Web page, but to update the addresses to the relative links on the Web page instead. You must save the moved or copied Web page for the updating to occur. Clear this check box to move or copy the supporting files when you move or copy a Web page. This is the default.

Default editor section

Check if Office is the default editor for Web pages created in Office     Select this check box to check whether a Microsoft Office program is registered as the default editor for the Web page. If another program is registered as the default editor, Office displays a message asking whether you want to restore an Office program as the default editor when you save the Web page. This is the default. Clear this check box to not display this message.

Pictures tab

Target monitor     In the Screen size box, select a screen size. In the Pixels per inch box, select a pixel size.

Graphics and text can wrap differently, depending on the video resolution (the size of the screen elements relative to the screen size). The screen size that you specify can affect the size and layout of images in a workbook, including the gradient page backgrounds. The pixel size affects the size of graphics relative to the size of text on the screen.

Encoding tab

Reload the current document as     Select the language that you think the page is encoded in. This setting is also used when subsequent pages are loaded if the language encoding cannot be determined.

When you open a Web page, Office Excel tries to determine the encoding that is used for that page. If Excel displays the wrong characters when you open the page in a Web browser, you can select the encoding that the Web page should use. Try each encoding until you can read the text.

Save this document as     Select the encoding in which you want the Web page to be saved.

Always save Web pages in the default encoding     Select this check box to use the default encoding on your computer, and make the Save this document as box unavailable. Clear this check box to enable the Save this document as box and use the specified encoding. This setting is useful if you reuse pages from other sources and you want to store every page in one encoding. This is the default.

Fonts tab

Character set    Select the character set that the Web page should use.

Proportional font and Size     Select a font and size for normal text. The default is Arial, 10.

Fixed-width font and Size     Select a font and size for monospaced text. The default is Courier New, 10.

If the wrong font for a Web page or plain text file is applied when you import a Web page into Excel, you can select the character set that you think the page is encoded in. Then you can choose from a list of fonts that depends on the character set that you selected.