saving printing settings in excel 2007
 

In the older version of Excel when I saved the worksheet, it saved the
settings that I created on each page for tray, paper type, quality of the
print, etc. In Excell 2007, when I save it those settings all go away. I
create worksheets with up to 20 pages in them and every time I want to print
I have to go to each page and reset the printing options. it is time
consuming and frustrating. How do I fix it?