Printing in excel?

[Dean]

I've created my own WIP ledger using pivot tables etc, but when I go to print a .PDF of it, it just comes up with blank sheets in adobe. If I print off a paper copy I get what I want i.e. the image displayed on screen. If I then scan the paper copy I get poor quality. Anyone know how to print .PDF pivot table data?

Regards

Dean

[catherinecleaver]

Do you use Cute pdf?

It's a free programme - you have to download it together with a converter which is also on the cute pdf site.
You can find it here:

http://www.cutepdf.com/Products/CutePDF/writer.asp

I have used it with all sorts of different programmes and have never had a problem with it. It lodges itself as some sort of virtual printer, and you just change to it instead of your normal printer. It then comes up with the "save as" window instead of actually printing it. I don't do such complicated things as pivot tables though, but it does do straightforward copies of accounts with all sorts of macros and formulae.

Good Luck
Catherine

[Dean]

Hi Catherine, thanks for your reply. I'm afraid i've never used cute pdf, we use adobe and it does exactly as you described. For some reason (I may not have 'ticked' a box or something) adobe can't produce the image on screen, I just get blank pages.

Regards

Dean

[deanshepherd]

I use cute pdf. It's free and has always worked for me. It's a very quick install/uninstall. Give it a try and see if that works then you willl know if it is a problem with adobe or whether it is something within Excel preventing it.

[Dean]

Tried... and failed :glare: must be something to do with excel.

Regards

Dean