Hi,

I have a strange problem where I can't find a solution for:
I'm printing several worksheets of an Excel file (Excel 2010). Some worksheets are really small and fit easily on 1 page, some have a lot of data and would take more than 20 pages.

When I try to change the "Scale to fit" setting under Page Layout for these bigger worksheets, I'll get an inconsistent number of total pages in the footer. I use for all worksheets 
Please Login or Register  to view this content.
to calculate the total pages.

Print Preview shows a consistens incorrect number of all pages. When I print, the smaller worksheets have the incorrect amount, the big worksheet which was scalled down to fit on 1 page on width shows the correct amount.

It seems to work if I don't change the "Scale to fit" seeting and just go with 100%. Unfortunutely I will more than 80 pages in total and the formatting doesn't look like it should be.


Does anyone encountered the same problem? I couldn't find a solution.
Any helps or tipps are higly appreciated.

Thanks,
Sven