Excel document print quantity stuck on "2"

[wcorbit]

I have an excel 2004 document that has a single sheet in which every time I print, the preset quantity in the print set-up is "2". This is an excel sheet that is probably 10 yrs old and has been updated over the years, with the new versions of excel. I know that it is not an OS X Printer set-up issue, because the problem is only isolated to this one sheet. I can't copy all the data to a new worksheet, because there are other worksheets that are linked to this one. My guess is that there is a glitch in the data/code for this one worksheet somewhere...any ideas on how to try and correct the problem?

Thanks

 

[Gregg2]

I would open a new document, format the rows and columns the same with Paste Special, then copy and paste the glitchy one to the new one and Save.