Excel printing problem

ermintrude1

Hi

Can anyone help with an annoying problem that has just started in the last couple of days?

I use a multi page excel file on a daily basis, the stupid problem is when I go to print one of the pages from the printer button on the top toolbar it has reset its default to two copies. So each time I want a single print I have to access the file/print menu and enter 1

I've tried saving, rebooting, gone into printer properties to no avail. The other spreadsheets in the file are all ok.

Any suggestions appreciated.

Dave_C_2

Try this method, based on Excel 2003:

On the problem sheet:
Select File then Print then Properties
On the Layout tab select Advanced
Under Paper/Output look at Copy Count it will be set at 2 copies, Click on 2 Copies and change it back to 1 copy
OK, OK, Close
Save the Excel file
Job done

Dave

ermintrude1

Thanks for that, I'll have a look for that.