Got a bit of a weird one here, and I hope I'm missing something obvious.
I have a workbook with 19 worksheets that make up a nicely formatted report. Each sheet has been set with the "Page 1 of ?" in the centre footer. Altogether there are 27 pages that should printed (some worksheets have more than 1 page) when I print the entire workbook. When I print however it is showing page 1 of 49, and I can't figure out why. There are no hidden worksheets, and when I highlight every sheet and look in print preview, it shows page 1 of 27. Anyone got any ideas?
I have a workbook with 19 worksheets that make up a nicely formatted report. Each sheet has been set with the "Page 1 of ?" in the centre footer. Altogether there are 27 pages that should printed (some worksheets have more than 1 page) when I print the entire workbook. When I print however it is showing page 1 of 49, and I can't figure out why. There are no hidden worksheets, and when I highlight every sheet and look in print preview, it shows page 1 of 27. Anyone got any ideas?