Print vs Print Preview - Total Page Numbers Issue

Using Excel 2003 I am printing multiple sheets. I have a footer on every sheet that is in the format of: page # of total pages.

When I do a print preview page number and total number of pages looks correct on every page.

However when I actually print the file the total number of pages varies and some of the sheets have wildly incorrect total number of pages (i.e. 26 total pages instead of 16 and other variations).

In doing some searches in the message boards and yes my default print driver is the same as the the one I am actually using.

I have checked various page setup options all looks "safe".

The only thing I can think of is I am using PDF Creator as my print driver. Due to various reasons I have not had a chance to test with other print drivers except for doing Print Preview but not actually doing Print.

I would have thought that as PDF Creator from PDFforge http://www.pdfforge.org/products/pdfcreator should work fine on this file as I do this all the time on other Excel files with the product. All it is doing is just capturing the print format output.

Any thoughts or ideas of something to check.

I will be doing more testing and report what I find, but would love to keep useing PDF Creator.

thanks

Alan