Solved

Printing Excel Document issue with setting number copies

Posted on 2009-05-04
3
165 Views
Last Modified: 2012-05-06
I have a excel 2003 workbook that constantly reverts to printing 20 copies not 2?
Its a simple excel form that has two pages per worksheet with ta total of two worksheets. First worksheet has two forms the second worksheet also has two forms.
If I click on the first worksheet it constatly shows 20 copies tp print, even though i have changed to 2 copies, and gone into properties and also cahnged to 2. If you then close the program and reopen it reverts back to 20 copies for [printing again?
If i however open the same workbook the second worksheet remains at 2 copies no problem?
Ideas?? There are no macros involved just simple forms?
0
Comment
Question by:Bazaza
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
jaydee-cdgp earned 125 total points
ID: 24301121
After you have changed from 20 to 2 copies, have you saved the workbook?
0
 

Author Comment

by:Bazaza
ID: 24318987
I changed the properties on the printer to only print 2, but again it changed back to 20. The name of the workbook had a space between it with the letters pdf at the end . e.g test pdf, i changed this to test_pdf and it then started to save the changes?

Cheers
0
 

Author Comment

by:Bazaza
ID: 24319026
It was the space in the workbook name that was creating the issue.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What does UTC stand for?  “Coordinated Universal Time” – Think of this as the true time on Planet Earth that never changes with the exception of minor leap seconds here and there to account for the changes in the planet's rotation.   What does th…
Find out what you should include to make the best professional email signature for your organization.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question