Continuous Paging in Excel worksheets problem!

Hello all,

I have an issue with continuous paging 2 worksheets of a file, I have selected the print area, ctrl + checked both sheets and THEN added footer with paging, but when I print-preview, first page is "Page 23 of 44" instead of Page 1

Any ideas of what could be going wrong?