Results 1 to 6 of 6
  1. #1
    New Lounger
    Join Date
    Apr 2014
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 97 print settings

    I have an unusual "quirk" with my Microsoft Excel 97 SR-1. I won't really call it a problem, just an annoyance.

    I created a spreadsheet template for a report I produce monthly. When I finish and "Save As" to a new name, I need to print ONE COPY. For some reason, this file always wants to print SIX COPIES. It's easy to use (CTRL)(P) and change it to one, but I usually forget since this is the only file where this happens.

    I tried using (CTRL)(P), change the copies to (1), print and then immediately save. When I exit and re-enter, it has changed back to (6).

    I then tried opening an Excel blank and copied/pasted the original information. It changed the appearance so much I gave up trying to fix it.

    I think the file may have been created using an older Excel version, but I would like to have it run properly on my Windows XP (I know . . . I need to upgrade soon).

    Any ideas?

  2. #2
    New Lounger
    Join Date
    Mar 2014
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Any chance you can try to open/print it with a newer version of excel to see if that helps? Not as a permanent solution, just to see if that gives another hint. Also, maybe there are advanced printing options in a newer excel version (i would think so), that allow to set it to single print permanently. I know thats a long shot, but thats what i would try when there is no obvious solution. In case you use excel 2010 for example, http://www.excel-aid.com/excel-print...int-areas.html describes how to set the print area (i have NO idea if you can do that in excel 97). Maybe if you change the print area, the copy-count resets to 1? But again, tahts a long shot, but i would still open it in a newer (or actually older might work too) version to see if it still prints 6 copies.

  3. #3
    WS Lounge VIP mrjimphelps's Avatar
    Join Date
    Dec 2009
    Location
    USA
    Posts
    3,411
    Thanks
    447
    Thanked 406 Times in 378 Posts
    You might also try printing it using either an Excel viewer, Libre Office, or Open Office. If you can successfully open it using any of those programs, you can probably successfully print it.

  4. #4
    Silver Lounger wavy's Avatar
    Join Date
    Dec 2009
    Location
    ny
    Posts
    2,380
    Thanks
    235
    Thanked 147 Times in 136 Posts

    I will check my Excel 97 when I get home. Is it possible there is some macro involved??









  5. #5
    New Lounger
    Join Date
    Mar 2014
    Posts
    4
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have no idea tbh since i dont really know alot about makros. But it seems unlikely unless you used one yourself i guess?

  6. #6
    Silver Lounger wavy's Avatar
    Join Date
    Dec 2009
    Location
    ny
    Posts
    2,380
    Thanks
    235
    Thanked 147 Times in 136 Posts

    I had no luck finding any option to change the number of copies in Excel. Maybe something to do with your printer driver. Perhaps try creating a new printer.

    BTW was not there a SR-2 for office 97 ??



Posting Permissions

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