Good morning, all. I have an excel workbook that contains several sheets.
Each sheet contains several pages.
These pages have a header (&[Page]of &[Pages]) and it shows as 1 of 2 on the first tab. 1 of 4 on another tab and so forth.
I want to keep this.
When I print to PDF, it changes the header page numbers to 1 of 43.
I found this link Page number sheets when printing Entire Workbook
but cannot get it to work.
Any assistance would be helpful. I am using windows 2016 excel.
Each sheet contains several pages.
These pages have a header (&[Page]of &[Pages]) and it shows as 1 of 2 on the first tab. 1 of 4 on another tab and so forth.
I want to keep this.
When I print to PDF, it changes the header page numbers to 1 of 43.
I found this link Page number sheets when printing Entire Workbook
but cannot get it to work.
Any assistance would be helpful. I am using windows 2016 excel.
