Adobe PDF Printer (2003)

Topic

New Reply

Hi All,

We have a custom build excel application (which I cannot share) and we have noticed that when we set the default printer to Adobe PDF then various things slow down alot. It seems that excel wants to recalculate things but we aren’t certain.

Any suggestions (and I know that I haven’t given you much to go on)?

Reply | Quote

Replies

If you turn calculations to manual in tools – options, are things still slow?

Steve

Reply | Quote

Firstly, turning calc to manual doesn’t seem to make any time difference.

secontly, more info: we continued reviewing the steps our code was performing and found the bottle neck to be in the part that checks that the columns widths are ok (ie no ####s). I borrowed some code from post 490,558. It seems to be a combination of column widths and the adobe printer.

Reply | Quote

What part of the code is slow?

Does turning screenupdating off help any?

Steve

Reply | Quote

We haven’t tracked it down to any particular line of code at present. Also, screen updating is off.

We are thinking that it is the column.autofit, followed by the column.width resets that is taking all the time. We have about 30 sheets with about 10-12 (on average) columns per sheet. All this work for the rare column that might need to be widened – . We are currently looking at flagging columns that might need column width checking and only processing those columns.

And for some strange reason – it is much slower with the adobe pdf printer rather than a ‘real’ printer.

I’ll do some more research tonight or tomorrow and give some feedback on individual line performance.

Reply | Quote

Methods like AutoFit tend to call the print driver to render the image (I don’t know for sure that AutoFit calls the print driver, but my guess would be yes). If the print driver is slow (and the PDF driver is very slow), then the application is going to be slow.

Reply | Quote