Microsoft KB Archive/87987

{| = Excel Err Msg: Margins Do Not Fit Page Size =
 * width="100%"|

Last reviewed: November 4, 1994

Article ID: Q87987 The information in this article applies to:


 * Microsoft Excel for Windows, versions 3.0, 4.0

SUMMARY
Under certain conditions, Microsoft Excel displays the error message, &quot;Margins do not fit page size&quot; even when the margin settings are appropriate for the selected paper size and page orientation. This happens when the new margin settings are inappropriate for the paper size and page orientation settings that were in effect when you opened the Page Setup dialog box. This may also occur if you have a corrupted printer driver.

MORE INFORMATION
Microsoft Excel updates your margin settings before updating your paper size and orientation settings. As a result, when you change the paper size or page orientation and then choose the OK button, Microsoft Excel checks your margin settings against the old paper size and page orientation settings. Microsoft Excel returns the error if your new margin settings aren't appropriate for the old paper size and page orientation settings.

Workaround #1
Since the margin information is saved to the worksheet itself, you can copy the problem sheet onto a new worksheet. The new worksheet will contain the default page setup settings and should not exhibit the problem.

Workaround #2
The workaround is to close the Page Setup dialog box after making changes to paper size or page orientation and before making changes to margins. This is only necessary if you are changing margins as well as paper size or orientation.

For example:


 * 1) From the File menu, choose Page Setup.
 * 2) Make any changes to paper size and page orientation.
 * 3) Choose the OK button.
 * 4) From the File menu, choose Page Setup again.
 * 5) Make your margin changes.
 * 6) Choose the OK button.

By closing the Page Setup dialog box between these operations you ensure that Microsoft Excel checks your new margins against the paper size and page orientation you are currently using. If these workarounds do not fix the problem, you should try to reinstall the printer driver.