The page setup settings in a shared workbook are different for each user in Excel (302911)
The information in this article applies to:
- Microsoft Office Excel 2003
- Microsoft Excel 2002
- Microsoft Excel 2000
This article was previously published under Q302911 SYMPTOMSIn Microsoft Excel, when you save a shared workbook with
page setup settings defined, and then another user opens the workbook, the
second user may not see the page setup settings that you created.CAUSE This problem occurs because, by default, the print settings
are saved in a custom view that is created for each person who uses the shared
workbook. The page setup settings, such as the header, the footer, and the page
breaks, are included in those print settings. RESOLUTION To resolve this problem, follow these steps:
- Open the shared workbook in Excel.
- On the Tools menu, click Share
Workbook.
- In the Share Workbook dialog box, click to
clear the Allow changes by more than one user at the same time
check box, and then click OK.
- On the View menu, click Custom
Views.
- In the Views dialog box, select each
custom view, and then click Delete to remove it.
- After you delete all the views, click
OK.
- Save the workbook.
- On the File menu, select Page
Setup.
Use the Page Setup dialog box to
create the print settings that you want all the users to see, and then click
OK when you are finished. - On the Tools menu, click Share
Workbook.
- On the Editing tab, click to select the
Allow changes by more than one user at the same time check
box.
- On the Advanced tab, click to clear the
Print settings check box in personal views.
- Click OK.
Modification Type: | Major | Last Reviewed: | 4/2/2004 |
---|
Keywords: | kbprb KB302911 |
---|
|