Different print outcome from print preview

I have an excel document where the "print area" is controlled through "name manager". It uses the offset function and reads a row variable to decide how many rows the "print area" has.

The issue is when I go into print preview, though the document is shown as 2 pages, the printing outcome is 3 pages. While the document supposed to print as 3 pages, the actual outcome would be 4 pages. The printing outcome is always 1 page more than whatever is supposed to print as shown in print preview.