Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts

    Default Number of Pages (2002, 2003)

    I have inherited a workbook that was created on another PC where the default printer setting was to print 3 copies.
    I thought if I moved the sheets to a new workbook on my PC (where the default setting is 1 copy) that it would be fine...but, nope.
    I've tried making a copy of the sheets in a new workbook, and also tried CTRL+A and then a paste (but, that has add'l problems because of the row and column settings, graphs in the sheet, etc. -- it doesn't all flow over correctly from a simple copy and paste).

    Any suggestions??

    (FIXED IT...not totally sure why it worked, but I copied the sheets to a new workbook and changed the settings in the advanced options on the printer, resaved the workbook and the issue went away.)

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Default Number of Pages (2002, 2003)

    Have you tried opening the workbook, and printing one copy of each worksheet, and then SAVE the workbook?
    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •