Solved

Printing Excel Document issue with setting number copies

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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Is your Office 365 signature not working the way you want it to? Are signature updates taking up too much of your time? Let's run through the most common problems that an IT administrator can encounter when dealing with Office 365 email signatures.
In this step by step procedure, you will come to know the details of creating an Outlook meeting in 2007, 2010, 2013 & 2016.
Many of my clients call in with monstrous Gmail overloading issues with Outlook. A quick tip is to turn off the All Mail and Important folders from synching. Here is a quick video I made to show you how to turn off these and other folders in Gmail s…
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…

756 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