Microsoft KB Archive/163271

= XL97: Error Appears or View Not Retained Printing Reports =

Article ID: 163271

Article Last Modified on 9/7/2001

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q163271



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 ' ' no longer exists.

where 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:

 Set the print area for the new view. Show and/or hide any rows and/or columns you want. Set filters as desired.

After you perform these steps, create the new view. Using the Report Manager, manually recreate the reports in your workbook.</li></ol>

<div class="status_section">

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

<div class="moreinformation_section">

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.

Additional query words: 97 XL97 fixlist97sr1

Keywords: kberrmsg kbprint kbualink97 kbprb KB163271

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.