I am trying to print multiple worksheets (specifically, a 19-worksheet workbook) and I want each worksheet to contain the next sequential page number (i.e. worksheet #7 will read "Page 7 of 19" in the right-hand footer; each worksheet is only one printed page).

The only way I know to do this is to input "Page &[Page] of 19" in the footer and change the "First Page Number" on each worksheet. I have tried this twice now (and saved after both times), but Excel does not keep the First Page Number that I assign to each worksheet.

For example, worksheet 7 reads "Page 1 of 19" because Excel has not retained the First Page Number of 7 that I set for that worksheet. I have tried a few times, but do not know why Excel is not saving this information. Any ideas?