XL97: Error Appears or View Not Retained Printing Reports (163271)

SYMPTOMS

When you print a report using the Report Manager in Microsoft Excel 97, you may receive an error message similar to the following:

View '<name of view>' no longer exists.

where <name of view> is the name of the view you are attempting to print.

When you click OK, you receive the following error message:

The report print job has been cancelled.

When you select a view in the Custom Views dialog box in Microsoft Excel 97, and then click Show, the print area for that view is not retained.

CAUSE

This behavior occurs when the following conditions are true:

You attempt to print a report that you created in Microsoft Excel 5.0 or 7.0. -or-
You attempt to display a view that you created in Microsoft Excel 5.0 or 7.0.

Note that views and reports that you create in Microsoft Excel 97 are printed correctly.

RESOLUTION

To correct this problem, install Microsoft Excel 97 Service Release 1 (SR-1).

To work around this problem, use the following steps:

Using the Custom Views add-in in Microsoft Excel 97, manually recreate all of the views in the workbook.

NOTE: You must perform the following steps BEFORE you create each view:
1. Set the print area for the new view.
2. Show and/or hide any rows and/or columns you want.
3. Set filters as desired.
After you perform these steps, create the new view.
Using the Report Manager, manually recreate the reports in your workbook.

STATUS

Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows. This problem was corrected in Microsoft Excel 97 for Windows, Service Release 1.

For additional information about SR-1, please see the following article in the Microsoft Knowledge Base:

172475 OFF97: How to Obtain and Install MS Office 97 SR-1

MORE INFORMATION

In Microsoft Excel, you can use the Custom Views add-in (also known as the View Manager) to create a view in a workbook. A view can consist of the following:

Print area settings
Hidden row and column settings
Filter settings

After you create a view, you can use the Report Manager to print it. You can print views in any order. This allows you to print information from multiple worksheets in a workbook in a single print job.

In Microsoft Excel 97, if you attempt to show a view that is created in Microsoft Excel 5.0 or 7.0, the print area for that view is not retained. This is true even though the view appears in the Custom Views dialog box.