Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Printing Excel Document issue with setting number copies

Posted on 2009-05-04
3
Medium Priority
?
181 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 6

Accepted Solution

by:
jaydee-cdgp earned 375 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

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
Changing a few Outlook Options can help keep you organized!
This Experts Exchange video Micro Tutorial shows how to tell Microsoft Office that a word is NOT spelled correctly. Microsoft Office has a built-in, main dictionary that is shared by Office apps, including Excel, Outlook, PowerPoint, and Word. When …
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

704 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