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
Solved

Printing Excel Document issue with setting number copies

Posted on 2009-05-04
3
166 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
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: …
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…

792 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