Link to home
Start Free TrialLog in
Avatar of roger190667
roger190667

asked on

excel convert to pdf problem

when a new work sheet is added to a multi worksheet document and you then ask it to print to pdf or xps it will stop at that sheet and then you have to convert the new sheet and then carry on to do the rest.
If you copy a sheet and then delete its contents it will convert the whole file with no problems
any idea why you cant just add a new sheet and convert to pdf
ASKER CERTIFIED SOLUTION
Avatar of MaximR
MaximR

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hi Roger,

I tried this with a 11 sheets workbook, I added a new one, changed the tab name an printed all at once on the PDFcreator printer.
Out came a pdf including the new tab?

Can't reproduce, can you tell me wich PDF convertor you are using?

KR

Eric
Avatar of roger190667
roger190667

ASKER

Hi Zwiekhorst

I am using acrobat adobe writer 9 but also happens if i use mirosoft xps document writer

Regards

Roger
This turned out to be in the page layout and the dpi settings.
on further investigations it seems that when excel finds a sheet with different  dpi settings it sees it as a seperate print job