Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 939748 - Last Review: July 19, 2007 - Revision: 1.0
You cannot permanently change the value of the "Number of copies" setting for Product Mix worksheet and for the Maximizing Income worksheet in the Solvsamp.xls file in Excel
In Microsoft Office Excel, when you print the Product Mix worksheet in the Solvsamp.xls file, the number of printed copies of the worksheet is
12,334. You may also notice that the value of the
Number of copies setting for the Maximizing Income worksheet in the
Print dialog box is
-1. However, you cannot permanently change the value of the
Number of copies setting for the worksheets.
Note The Solvsamp.xls file is a sample workbook for Excel. You can find the file for different versions of Excel in the SAMPLES folder in the Office installation folder.
- For Microsoft Office Excel 2007, the Solvsamp.xls file is located in the following folder:
C:\Program Files\Microsoft Office\Office12\SAMPLES
- For Microsoft Office Excel 2003, the Solvsamp.xls file is located in the following folder:
C:\Program Files\Microsoft Office\Office11\SAMPLES
- For Microsoft Excel 2002, the Solvsamp.xls file is located in the following folder:
C:\Program Files\Microsoft Office\Office10\SAMPLES
- For earlier versions of Excel, the Solvsamp.xls file is located in the following folder:
C:\Program Files\Microsoft Office\Office\SAMPLES
This problem occurs because the worksheets contain the default value of the
Number of copies setting. When you try to change the value, the new value cannot be saved with the workbook.
To work around this problem, use one of the following methods.
Method 1
Change the value of the
Number of copies setting in the
Print dialog box every time that you print the worksheet.
Method 2
- Copy the data from the affected worksheet to a new worksheet, and then delete the original worksheet.
- Rename the new worksheet by using the name of the original worksheet, verify that the value of the Number of copies setting for the worksheet is 1, and then save the workbook.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
APPLIES TO
- Microsoft Office Excel 2007
- Microsoft Office Excel 2003
- Microsoft Excel 2002 Standard Edition
- Microsoft Excel 2000 Standard Edition
- Microsoft Excel 97 Standard Edition
| kbtshoot kbprb kbexpertisebeginner KB939748 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate