Hi, I have an Excel 2010 workboook with 15 sheets. Each sheet is multiple pages and has a footer with the sheet name & page number on it.
When I save the workbook as a PDF, the sheet name stays, however the page number seems to revert to sequential page numbers within the PDF.
(IE Sheet 1 footer is named "CA" and in my excel doc has pages 1-5, Sheet 2 is named "CR" and in my excel doc has pages 1-10. When I convert to PDF the pages in Sheet 1 are fine - because they actually are pages 1-5, but the page number for the first page of Sheet 2 becomes "CR 6" instead of back to "CR 1")
Does anyone know how I can maintain the page numbers the way they are in the excel doc?
Thanks Much!
When I save the workbook as a PDF, the sheet name stays, however the page number seems to revert to sequential page numbers within the PDF.
(IE Sheet 1 footer is named "CA" and in my excel doc has pages 1-5, Sheet 2 is named "CR" and in my excel doc has pages 1-10. When I convert to PDF the pages in Sheet 1 are fine - because they actually are pages 1-5, but the page number for the first page of Sheet 2 becomes "CR 6" instead of back to "CR 1")
Does anyone know how I can maintain the page numbers the way they are in the excel doc?
Thanks Much!
