• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 194
  • Last Modified:

Printing Excel Document issue with setting number copies

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
Bazaza
Asked:
Bazaza
  • 2
1 Solution
 
jaydee-cdgpCommented:
After you have changed from 20 to 2 copies, have you saved the workbook?
0
 
BazazaAuthor Commented:
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
 
BazazaAuthor Commented:
It was the space in the workbook name that was creating the issue.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now