ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Saving A 30 Page Report As A PDF (https://www.excelbanter.com/excel-discussion-misc-queries/210902-saving-30-page-report-pdf.html)

[email protected]

Saving A 30 Page Report As A PDF
 
Hey Everyone,

I have a 30 page report I put together every month for a management
meeting. I do this By going to Page Break Preview and then after I
have all of my charts layed out how I want them (it's actually like
35-40 charts), I go to the office button and save it as a PDF. It
takes FOREVER to do this, and after reviewing it, if there is anything
wrong, I have to do it all over again.

My question is - is there a better way to do this? I am pretty good
with excel, programming, etc. I would really like to speed up this
process and I don't think the Save As PDF feature is meant to handle
30 page reports.

Sheeloo[_3_]

Saving A 30 Page Report As A PDF
 
I use CutPDF to convert any file to PDF... It gives you a copy similar to the
one you will get on paper.

" wrote:

Hey Everyone,

I have a 30 page report I put together every month for a management
meeting. I do this By going to Page Break Preview and then after I
have all of my charts layed out how I want them (it's actually like
35-40 charts), I go to the office button and save it as a PDF. It
takes FOREVER to do this, and after reviewing it, if there is anything
wrong, I have to do it all over again.

My question is - is there a better way to do this? I am pretty good
with excel, programming, etc. I would really like to speed up this
process and I don't think the Save As PDF feature is meant to handle
30 page reports.


Abbey

Saving A 30 Page Report As A PDF
 


" wrote:

Hey Everyone,

I have a 30 page report I put together every month for a management
meeting. I do this By going to Page Break Preview and then after I
have all of my charts layed out how I want them (it's actually like
35-40 charts), I go to the office button and save it as a PDF. It
takes FOREVER to do this, and after reviewing it, if there is anything
wrong, I have to do it all over again.

My question is - is there a better way to do this? I am pretty good
with excel, programming, etc. I would really like to speed up this
process and I don't think the Save As PDF feature is meant to handle
30 page reports.


I actually copy and paste the pages Per page break into word (as pictures)
and convert to PDF - thus my output is as i want it. However, you must have
double checked your excel doc. for accuracy etc, else you'd have to start
over again to make corrections

[email protected]

Saving A 30 Page Report As A PDF
 
On Nov 19, 10:16 am, Abbey wrote:
" wrote:
Hey Everyone,


I have a 30 page report I put together every month for a management
meeting. I do this By going to Page Break Preview and then after I
have all of my charts layed out how I want them (it's actually like
35-40 charts), I go to the office button and save it as a PDF. It
takes FOREVER to do this, and after reviewing it, if there is anything
wrong, I have to do it all over again.


My question is - is there a better way to do this? I am pretty good
with excel, programming, etc. I would really like to speed up this
process and I don't think the Save As PDF feature is meant to handle
30 page reports.


I actually copy and paste the pages Per page break into word (as pictures)
and convert to PDF - thus my output is as i want it. However, you must have
double checked your excel doc. for accuracy etc, else you'd have to start
over again to make corrections


Thank you for the feedback. I will try those methods from now on...


All times are GMT +1. The time now is 08:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com