Excel: Cannot Page Through Multiple Windows of Same Document

ID: Q82083

The information in this article applies to:

Microsoft Excel for Windows, version 4.0
Microsoft Excel for the Macintosh, version 4.0

SUMMARY

When in a Microsoft Excel version 4.0 Workbook, you can page through bound and unbound documents by selecting the Paging button on the lower right side of the Workbook Window. If, however, you have multiple windows of the same document, you will not be able to page through the different windows.

MORE INFORMATION

The particular window displayed when paging to a document with multiple windows will either be window number one or the last one that was displayed within the Workbook. This functionality is best illustrated with the following example.

Example

From the File menu, choose New. Select Worksheet and choose OK.

From the File menu, choose New. Select Workbook and choose OK.

Choose the Add button on the Workbook. Select the new worksheet and choose OK.

Choose the Next Page button in the lower right corner. The worksheet will now be active.

From the Window menu, choose New Window. You will now see window number two for the document, designated "SHEET1:2" (without quotation marks) in Microsoft Excel for Windows. In Microsoft Excel for the Macintosh, this will be designated "WORKSHEET1:2".

Choose the Next Page button. You will now be returned to the Workbook.

Choose the Next Page button once more and you will be returned to SHEET1:2 in Windows or WORKSHEET1:2 on the Macintosh. The second window view was the last displayed for the document.

If you were to now select window number one from the Window menu, page to the Workbook and back to the document, you would see SHEET1:1 or WORKSHEET1:1 displayed. At this point, you will not be able to access the second window view from the Window menu or by paging. The only way to display the second window view is to unbind the document and then save and open it as a separate file. All of the window views that were created will be saved with the document.

Additional query words:


Keywords          : 
Version           : 
Platform          : 
Issue type        :

Last Reviewed: March 24, 1999